Spreadsheet: 846104d1697422319-help-with-dateif-formula-long-service-leave-current
Sheet: Sheet3

EMPLOYEE NO | FIRST NAME | SURNAME | STORE TRADING NAME | LEGAL ENTITY | START DATE | TODAYS DATE | LENGTH OF SERVICE | LENGTH OF MAT LEAVE | COMPLETE LENGTH OF SERVICE
 |  |  |  |  | 2004-10-11 00:00:00
 |  |  |  |  | 2006-02-01 00:00:00
 |  |  |  |  | 2006-08-04 00:00:00
 |  |  |  |  | 2008-01-30 00:00:00
 |  |  |  |  | 2008-09-03 00:00:00
 |  |  |  |  | 2009-04-29 00:00:00
 |  |  |  |  | 2009-03-31 00:00:00
 |  |  |  |  | 2010-04-13 00:00:00
 |  |  |  |  | 2011-05-23 00:00:00
 |  |  |  |  | 2011-06-28 00:00:00
 |  |  |  |  | 2013-03-04 00:00:00
 |  |  |  |  | 2013-05-27 00:00:00
 |  |  |  |  | 2013-06-05 00:00:00
 |  |  |  |  | 2013-08-05 00:00:00
 |  |  |  |  | 2014-09-16 00:00:00
 |  |  |  |  | 2014-10-06 00:00:00
 |  |  |  |  | 2014-12-01 00:00:00
 |  |  |  |  | 2015-03-23 00:00:00
 |  |  |  |  | 2015-07-16 00:00:00
 |  |  |  |  | 2016-01-29 00:00:00
 |  |  |  |  | 2016-05-16 00:00:00
 |  |  |  |  | 2016-06-08 00:00:00
 |  |  |  |  | 2016-09-01 00:00:00
 |  |  |  |  | 2017-01-10 00:00:00
 |  |  |  |  | 2017-04-19 00:00:00
 |  |  |  |  | 2017-05-18 00:00:00
 |  |  |  |  | 2017-06-05 00:00:00
 |  |  |  |  | 2017-09-04 00:00:00
 |  |  |  |  | 2017-10-04 00:00:00
 |  |  |  |  | 2017-11-28 00:00:00
 |  |  |  |  | 2018-05-08 00:00:00
 |  |  |  |  | 2018-05-21 00:00:00
 |  |  |  |  | 2018-06-25 00:00:00
 |  |  |  |  | 2018-07-19 00:00:00
 |  |  |  |  | 2018-07-30 00:00:00
 |  |  |  |  | 2018-08-08 00:00:00
 |  |  |  |  | 2018-08-13 00:00:00
 |  |  |  |  | 2018-08-15 00:00:00
 |  |  |  |  | 2018-12-18 00:00:00
 |  |  |  |  | 2019-01-31 00:00:00
 |  |  |  |  | 2019-02-08 00:00:00
 |  |  |  |  | 2019-02-14 00:00:00
 |  |  |  |  | 2019-04-09 00:00:00
 |  |  |  |  | 2019-10-29 00:00:00
 |  |  |  |  | 2019-11-11 00:00:00
 |  |  |  |  | 2020-01-26 00:00:00
 |  |  |  |  | 2020-02-26 00:00:00
 |  |  |  |  | 2020-03-10 00:00:00
 |  |  |  |  | 2020-04-02 00:00:00
 |  |  |  |  | 2020-04-16 00:00:00
 |  |  |  |  | 2020-05-01 00:00:00
 |  |  |  |  | 2020-08-03 00:00:00
 |  |  |  |  | 2020-10-09 00:00:00
 |  |  |  |  | 2020-11-09 00:00:00
 |  |  |  |  | 2020-11-11 00:00:00
 |  |  |  |  | 2020-11-16 00:00:00
 |  |  |  |  | 2020-11-23 00:00:00
 |  |  |  |  | 2020-12-22 00:00:00
 |  |  |  |  | 2021-01-13 00:00:00
 |  |  |  |  | 2021-03-09 00:00:00
 |  |  |  |  | 2021-03-26 00:00:00
 |  |  |  |  | 2021-05-10 00:00:00
 |  |  |  |  | 2021-05-17 00:00:00
 |  |  |  |  | 2021-05-20 00:00:00
 |  |  |  |  | 2021-07-07 00:00:00
 |  |  |  |  | 2021-07-09 00:00:00
 |  |  |  |  | 2021-09-13 00:00:00
 |  |  |  |  | 2021-10-07 00:00:00
 |  |  |  |  | 2021-11-08 00:00:00
 |  |  |  |  | 2021-11-19 00:00:00
 |  |  |  |  | 2021-12-09 00:00:00
 |  |  |  |  | 2021-12-12 00:00:00
 |  |  |  |  | 2022-01-04 00:00:00
 |  |  |  |  | 2022-01-10 00:00:00
 |  |  |  |  | 2022-02-15 00:00:00
 |  |  |  |  | 2022-02-15 00:00:00
 |  |  |  |  | 2022-02-25 00:00:00
 |  |  |  |  | 2022-02-25 00:00:00
 |  |  |  |  | 2022-02-28 00:00:00
 |  |  |  |  | 2022-03-03 00:00:00
 |  |  |  |  | 2022-03-11 00:00:00
 |  |  |  |  | 2022-03-23 00:00:00
 |  |  |  |  | 2022-03-24 00:00:00
 |  |  |  |  | 2022-03-29 00:00:00
 |  |  |  |  | 2022-04-20 00:00:00
 |  |  |  |  | 2022-05-05 00:00:00
 |  |  |  |  | 2022-05-20 00:00:00
 |  |  |  |  | 2022-05-20 00:00:00
 |  |  |  |  | 2022-05-28 00:00:00