Holiday Entitlement spreadsheet

[Shelly8895]

Hi,

New to this so bare with me!

I am trying to create a holiday entitlement spreadsheet where I can calculate what holiday my staff have remaining throughout the year dependent on A how much they have taken and B) when they started.

So for example holiday year runs Jan - Dec on standard 20 day holiday allowance, the employee started in April so I need a formula to work out what that person is entitled to for the rest of the year and I then also need to a formula that changes every time they take a holiday in the year.

I hope this makes sense!!


Please help!!

[etaf]

how is your spreadsheet set out
perhaps you could load an example

[easyexcelanswers]

to calculate the difference months

=DATEDIF(C1,D1,"m")

C1 would be the year start date

D1 would be the actual start date

the result would be in months which could be subtracted from 20 and the result multiplied by 1.6667 which would be
the holiday entitlement

http://easyexcelanswers.com/dates.ht... between dates