Length of Service and Vacation Hours Accrued

[WilliamsDeLisle]

IF Statement would be If 0-60 months 8 Hours accrued each month, if
61-120 months 10 hours accrued each month, If 121-180 months 12 hours
accrued each month, if more than 181 months then 14 hours accrued each
month. When I try to put in an argument I get an error message.

**This accrual amount for each month must be used in the monthly column if
the worksheet for that month has 100% for the hours worked in cell C02 of
each month.

i.e.,:

Column A Column B
(Month) (Earned)**
JULY-08 ________ (see the description above)
AUG-08
SEPT-08
OCT-08
NOV-08

 

[Jacob Skaria]

Dear William

I am not sure how you are calculating the total months..I will give an
example which will help..Suppose

A1 = Start Date
B1 = End Date

The below forumla will calculate the total months between this dates and get
the hours accrued based on months and then calulate the total hours accrued.
Please try and feedback

=LOOKUP(DATEDIF(A1,B1,"m"),{0,61,121,181},{8,10,12,14})*DATEDIF(A1,B1,"m")

A break down of the formula to help you in future
=DATEDIF(A1,B1,"m") will give you the months between dates
=LOOKUP("<value>",{0,61,121,181},{8,10,12,14}) will lookup the corresponding
hours based on the total months

If this post helps click Yes

 

[WilliamsDeLisle]

This helped a great deal. Thank you.