Annual leave monthly calculation

[Tia]

hi

I have made an exel sheet to calculate the vacation leave for all the
employees
and i have used this formula

C7=starting date
=IF(TODAY()-C7>10*365,19,IF(TODAY()-C7>5*365,17,IF(TODAY()-
C7>0.25*365,15)))

But what i really need is to calculate their leave on monthly basis b
there is too much fractions in the total


Please advise
Tia

 

[David Biddulph]

If you want to calculate date differences by month, use the DATEDIF
function:
http://www.cpearson.com/excel/datedif.htm

 

[Pete_UK]

So, they are entitled to 19 days leave if they have worked for more than 10
years, 17 days if more than 5 years, and 15 days if more than 0.25 years?
All you need to do to get the per-month days is to divide 19, 17 and 15 by
12 in your formula. Then you can multiply this by the number of months since
the start of the year.

Hope this helps.

Pete