Oops. That formula should be

=VLOOKUP(DATEDIF(B2,TODAY(),"m"),$K$1:$L$4,2)



On Mon, 10 Jan 2005 12:48:55 -0600, Myrna Larson
wrote:

I think the easiest way would be to create a table to use with VLOOKUP that
has the required length of service (in months?) in the 1st column, and the
number of weeks varaction in the 2nd, i.e. something like

0 0
6 1
12 1.5
36 2.0

assuming they get no vacation until they have completed 6 months, then 1
month, increasing to 1.5 after 12 months, and to 2 after 36 months.

Then if you have the date of hire in, say, column B, and the above table is
in
cells K1:L4, the formula for vacation is

=VLOOKUP(B2,$K$1:$L$4,2)


On Mon, 10 Jan 2005 16:05:15 GMT, "Kim Campbell via OfficeKB.com"
wrote:

Hi,

I need help creating a formula to calculate accrued vacation time.
Employees
earn either 1, 1.5, or 2 days of vacation time on their anniversatry date
each
month. How can I create a forumla that will automatically compute everyone's
vacation time?

Thanks in advance for your help!