Calculating between 2 dates

[Lmaonade]

Hi guys, I have this spreadsheet.

I need to be able to work out how many days holiday each candidate has accrued based on todays date.

For example. Based on the amount of days worked per week and how long the contract is for, CAN-10367 will get 30 days holiday for the duration of his contract. how do I work out how much of that holiday he has accrued up to todays date.

I'm confusing myself a little.

Thanks in advance

 

[Norie]

How is the holiday allowance calculated?

 

[Lmaonade]

Holiday allowance is based on each candidate getting 8 weeks holiday for every 52 weeks (if working 5 days a week) so 40 days.

So for someone working 4 days a week for 52 weeks, they will earn 32 days holiday. I hope that makes sense.

 

[Lmaonade]

The yellow marked cells are usually hidden but this is how I worked out Holiday allowance.