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!!