Hiya

I would be grateful for any help on this – it is probably really simple and I am trying to over complicate things but I cannot get it right.

I would like a really simple formula to work out our staff holidays on a rolling day to day basis for example:-

Employee
John Smith

First Day
20 March 2014

Last Day
3 August 2014

Annual Holiday Entitlement
20 days

(I do not include bank holidays in this calculation as we sort them out separately).

Is there a formula to work out how many days holiday John is entitled to when he leaves the company?

Many thanks

Kathy