one way:

Assuming hire date in A1 and the number of days per year in B1:


If all vacation accrues on anniversary date:

=DATEDIF(A1,TODAY(),"y")*B1

If vacation accrues by month:

=DATEDIF(A1,TODAY(),"m") * B1/12


In article ,
"Painter" wrote:

I want to be able to put a formula in to a spreadsheet so that it will
automatically accrue vacation time for an employee by anniversary date. How
can I do this?