You can call me either Bernie. :-) I use one username for this forum & a different one for the microsoft forum.

Thanks again for your help on this!!! I understand better what this formula is doing now. Works great!

I have a similar worksheet that is for office employees only. So the criteria is a little different. You've already helped me with the first bullet below but how could I incorporate the following 2 bullets with the first bullet? See below:

Thanks!

*During first calendar year vacation will accrue at 3.34 hours per complete month of service.

*Beginning January 1 following the date of hire- employee will receive 80 hours each year.

*Beginning January 1 of tenth calendar year of service- employee will receive 120 hours each year.
Yesterday, 07:15 PM
Bernie Deitrick Posts: n/a

Re: Vacation Days Accrued

--------------------------------------------------------------------------------

jp (or is it np?),

5/5/97 is 103 months ago, not 84:

7 in 97, 12 each in 98, 99, 2000, 01, 02, 03, 04, and 12 again in 05.

103 * 3.34 = 344.02

P.S. You could improve the accuracy of the formulas by using 3 1/3 and 6
2/3 instead of the decimals....

Bernie
MS Excel MVP