ExcelBanter - Formulas

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Formulas (https://www.excelbanter.com/excel-programming/328326-formulas.html)

Painter

Formulas

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?

JE McGimpsey

Formulas

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?

All times are GMT +1. The time now is 07:29 AM.