ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Establishing Annual Leave Entitlement (https://www.excelbanter.com/excel-discussion-misc-queries/174881-establishing-annual-leave-entitlement.html)

Jo Launder

Establishing Annual Leave Entitlement
 
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[_2_]

Establishing Annual Leave Entitlement
 
Would you like to think again about what information might be relevant in
answering the question?
--
David Biddulph

"Jo Launder" <Jo wrote in message
...
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.




dlw

Establishing Annual Leave Entitlement
 
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

"Jo Launder" wrote:

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.



All times are GMT +1. The time now is 02:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com