hello all i have the following formula already set i just the formula to reference if the employee has worked more then then 1-2 years and 2-5 years:
B4 = Start date which for this example is - 4/27/12
D4 = Title which is "Cook"
E4 = Anniversary date which is =DATE(YEAR(TODAY()),MONTH(B4),DAY(B4))
F4 = Months since anniversary which is =IFERROR(DATEDIF(E4,$D$100,"m"),0)
J4 = =IFERROR(VLOOKUP($D4,$B$103:$C$110,2,FALSE)/12*F4,0) ---- which after 12 months returns what the employee accrues
B103:C110 = is the vlookup function to find what an employee accrues.
What im trying to do is if they have worked more then 2 years they now upgrade from 5 vacation days a year to 10. B103:C110 is looking for the title (D4) and teling us what the title or position name is entitled to but i want to incorporate in J4 is also if they work more then 2 years reference 10 days instead of the 5 days for 1-2 years of service.
thanks all
B4 = Start date which for this example is - 4/27/12
D4 = Title which is "Cook"
E4 = Anniversary date which is =DATE(YEAR(TODAY()),MONTH(B4),DAY(B4))
F4 = Months since anniversary which is =IFERROR(DATEDIF(E4,$D$100,"m"),0)
J4 = =IFERROR(VLOOKUP($D4,$B$103:$C$110,2,FALSE)/12*F4,0) ---- which after 12 months returns what the employee accrues
B103:C110 = is the vlookup function to find what an employee accrues.
What im trying to do is if they have worked more then 2 years they now upgrade from 5 vacation days a year to 10. B103:C110 is looking for the title (D4) and teling us what the title or position name is entitled to but i want to incorporate in J4 is also if they work more then 2 years reference 10 days instead of the 5 days for 1-2 years of service.
thanks all
