Establishing Annual Leave Entitlement

[Jo Launder]

Its that time of year when i need to work the teams annual leave entitlement
and i was wondering if i could set up an excel template to do this.

 

[David Biddulph]

Would you like to think again about what information might be relevant in
answering the question?

 

[dlw]

do a vlookup on a range that has years employed in one column and hours (or
days) of leave entitled in the other column.
subtract today from employment start date to get length of time employed