Annual Leave

[Guest]

I have a small number of employees who begin work with me at different times.
They each received 28 days Annual Leave which falls due on the day of their
anniversary. I need to calcualte the leave at any given time that they are
owed or have taken.

 

[Guest]

Hi Aussie Peter,

Would not Access databse be best for this? However Excel can do what you
ask and I make the following suggestion.

Two calculations seem to be required. First how many full years has the
person been working for you. Second how many days leave are owing.

First have the date of engagement in one cell say (A1) and locked out. In
the next cell (say B1) have this formula =INT((Now()-A1)/365). This will
give you the whole number of years since the person started work with you.
The total number of days leave since starting is then 28*B1, so in say cell
C1 put this formula in =28*B1.

Presumably you will have a column which records the number of days leave
taken (lets say D1) then the remaining days leave is simply in cell E1 place
the formula (C1-D1). So shifting the references across one column you would
likely have the persons name in column A, start date in Column B, a
calculated value (number of full years employed) in column C, a calculated
value for the total number of days leave taken since starting in column D and
the remaining days leave in column E.

Hope this is what you were after.

Regards from the kiwi,

DavidC