Spreadsheet: 865501d1712580739-combine-two-datedif-formulas-annual-leave-entitlement-for-forum
Sheet: Sheet1

SURNAME | FIRST NAME | Base A/L | Bank Holiday | Extra Bank Holiday | [NAME] | [NAME] in next Fiscal | % of Partial CS AL | [NAME] | Pro Rata CS AL | Total CS AL | Total Annual Leave | Work Time Equivalent | Annual Leave (Hours) | NHS continuous service date | 2024-03-31 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 0.5066666666666667 |  | 2012-01-30 00:00:00 |  |  |  |  |  |  |  |  |  | Last Date
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 2020-03-30 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 2019-05-01 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 2022-08-30 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 2023-09-11 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 2022-04-19 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 0.8 |  | 1999-01-11 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 0.8 |  | 2004-11-22 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 1985-07-22 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 0.8 |  | 2014-06-02 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 2000-03-13 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 2022-06-27 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 2001-05-08 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 2020-03-09 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 2021-11-01 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 2016-12-12 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 0.4 |  | 2012-03-12 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 0.8 |  | 2002-08-05 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 2022-03-14 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 2013-03-04 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 0.4 |  | 1979-04-21 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 2023-05-02 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 2024-01-29 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 2016-10-24 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 0.8 |  | 2005-09-26 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 2022-08-01 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 0.8 |  | 2023-05-02 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 2023-03-20 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 0.6000000000000001 |  | 2016-02-15 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 0.8 |  | 2003-12-01 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 0.8 |  | 2016-12-12 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 2020-09-01 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 2023-05-22 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 0.6000000000000001 |  | 2002-04-08 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 2002-12-11 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 2020-09-01 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 0.6000000000000001 |  | 2021-11-01 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 0.6000000000000001 |  | 2022-04-19 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 0.8 |  | 2020-11-30 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 2024-01-29 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 0.8 |  | 2021-08-23 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 0.6000000000000001 |  | 2020-09-28 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 2018-08-06 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 0.6000000000000001 |  | 1989-03-13 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 2006-05-22 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 0.8 |  | 2014-12-01 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 0.8 |  | 2022-08-30 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 0.6000000000000001 |  | 2022-08-01 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 2023-07-03 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 2023-03-20 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 2023-07-03 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 2018-11-19 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 2021-07-19 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 0.8 |  | 2017-12-11 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 2012-01-23 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 0.8 |  | 2003-03-10 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 2018-11-26 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 2022-11-28 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 2017-01-23 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 0.8 |  | 2021-06-01 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 0.8 |  | 2018-07-16 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 2019-01-28 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 0.6000000000000001 |  | 2023-04-17 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 0.4 |  | 1992-06-29 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 2024-01-29 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 2023-12-04 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 2021-11-01 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 0.8 |  | 2019-12-16 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 0.6000000000000001 |  | 2015-02-15 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 0.8 |  | 2018-01-08 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 0.8 |  | 2003-03-24 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 2023-08-21 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 0.8 |  | 2023-02-06 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 2003-02-10 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 0.4 |  | 1992-06-29 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 1998-12-14 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 2019-10-14 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 2023-02-09 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 1992-09-21 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 0.6000000000000001 |  | 2004-08-16 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 2020-06-01 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 2015-07-27 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 0.8 |  | 2017-04-03 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 2018-06-04 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 2024-02-19 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 2022-08-22 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 0.9 |  | 2019-11-04 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 2017-09-18 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 2013-04-02 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 1984-12-31 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 1 |  | 2018-09-24 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 0.6000000000000001 |  | 2021-01-04 00:00:00
 |  | 27 | 7 | 0 |  |  |  |  |  |  |  | 0.8 |  | 2018-07-23 00:00:00
Total Staff on [NAME]