Spreadsheet: 766275d1643824594-formula-to-restart-vacation-days-on-anniversary-date-manager-vacation-tracker
Sheet: Employee Leave Tracker

 | Employee [NAME]
 | Employee Name | Start Date | End Date | Type of Leave | Days | Notes
 | Employee 1 | 2021-04-07 00:00:00 | 2021-04-07 00:00:00 | [NAME] | 1
 | Employee 13 | 2021-04-05 00:00:00 | 2021-04-05 00:00:00 | Vacation | 1
 | Employee 13 | 2021-03-29 00:00:00 | 2021-03-30 00:00:00 | Vacation | 2
 | Employee 3 | 2021-02-24 00:00:00 | 2021-02-24 00:00:00 | Vacation | 1
 | Employee 5 | 2021-03-03 00:00:00 | 2021-03-03 00:00:00 | [NAME] | 1
 | Employee 5 | 2021-02-24 00:00:00 | 2021-02-24 00:00:00 | [NAME] | 1
 | Employee 14 | 2020-12-17 00:00:00 | 2020-12-17 00:00:00 | [NAME] | 1
 | Employee 14 | 2020-11-13 00:00:00 | 2020-11-13 00:00:00 | Unplanned Vacation | 1
 | Employee 14 | 2020-11-09 00:00:00 | 2020-11-09 00:00:00 | Unplanned Vacation | 1
 | Employee 14 | 2020-08-26 00:00:00 | 2020-08-26 00:00:00 | Unplanned Vacation | 1
 | Employee 14 | 2020-08-04 00:00:00 | 2020-08-07 00:00:00 | Vacation | 3
 | Employee 14 | 2020-07-27 00:00:00 | 2020-07-31 00:00:00 | Vacation | 5
 | Employee 14 | 2020-07-24 00:00:00 | 2020-07-24 00:00:00 | [NAME] | 1
 | Employee 14 | 2020-07-20 00:00:00 | 2020-07-23 00:00:00 | Vacation | 3 | !!!!!!
 | Employee 14 | 2020-07-02 00:00:00 | 2020-07-02 00:00:00 | Unplanned Vacation | 1 | !!!!!
 | Employee 14 | 2020-05-28 00:00:00 | 2020-05-28 00:00:00 | Unplanned Vacation | 1 | !!!!!!
 | Employee 12 | 2021-03-26 00:00:00 | 2021-03-26 00:00:00 | Unpaid | 1
 | Employee 12 | 2021-03-23 00:00:00 | 2021-03-25 00:00:00 | [NAME] | 3
 | Employee 6 | 2021-03-31 00:00:00 | 2021-03-31 00:00:00 | Unplanned Vacation | 7 | *Advancement
 | Employee 6 | 2020-12-20 00:00:00 | 2020-12-20 00:00:00 | Unplanned Vacation | 1 | *Various Leave Early Times
 | Employee 6 | 2020-12-18 00:00:00 | 2020-12-18 00:00:00 | Unplanned Vacation | 1
 | Employee 6 | 2020-12-17 00:00:00 | 2020-12-17 00:00:00 | [NAME] | 1
 | Employee 6 | 2020-10-26 00:00:00 | 2020-10-26 00:00:00 | [NAME] | 1
 | Employee 6 | 2020-09-25 00:00:00 | 2020-09-25 00:00:00 | Unplanned Vacation | 4 | *Advancement
 | Employee 6 | 2020-07-27 00:00:00 | 2020-07-27 00:00:00 | Unplanned Vacation | 1
 | Employee 6 | 2020-06-22 00:00:00 | 2020-06-22 00:00:00 | [NAME] | 1
 | Employee 6 | 2020-06-12 00:00:00 | 2020-06-12 00:00:00 | Unplanned Vacation | 4 | *Advancement
 | Employee 6 | 2020-03-06 00:00:00 | 2020-03-06 00:00:00 | Unplanned Vacation | 4 | *Advancement
 | Employee 18 | 2021-04-07 00:00:00 | 2021-04-07 00:00:00 | Unpaid | 1
 | Employee 18 | 2021-03-02 00:00:00 | 2021-03-02 00:00:00 | Unplanned Vacation | 1
 | Employee 18 | 2021-01-27 00:00:00 | 2021-01-27 00:00:00 | Unplanned Vacation | 1
 | Employee 18 | 2021-01-12 00:00:00 | 2021-01-12 00:00:00 | Unplanned Vacation | 1
 | Employee 18 | 2020-12-29 00:00:00 | 2020-12-30 00:00:00 | [NAME] | 2
 | Employee 18 | 2020-12-17 00:00:00 | 2020-12-17 00:00:00 | [NAME] | 1
 | Employee 10 | 2021-04-06 00:00:00 | 2021-04-06 00:00:00 | Vacation | 1
 | Employee 10 | 2021-03-12 00:00:00 | 2021-03-12 00:00:00 | Vacation | 1
 | Employee 10 | 2021-03-11 00:00:00 | 2021-03-11 00:00:00 | [NAME] | 0.375
 | Employee 10 | 2021-03-08 00:00:00 | 2021-03-08 00:00:00 | Vacation | 1
 | Employee 10 | 2020-12-18 00:00:00 | 2020-12-18 00:00:00 | [NAME] | 0.375
 | Employee 10 | 2020-12-17 00:00:00 | 2020-12-17 00:00:00 | Vacation | 1
 | Employee 10 | 2020-11-25 00:00:00 | 2020-11-25 00:00:00 | Vacation | 1
 | Employee 10 | 2020-11-24 00:00:00 | 2020-11-24 00:00:00 | [NAME] | 1
 | Employee 10 | 2020-11-02 00:00:00 | 2020-11-06 00:00:00 | Vacation | 5
 | Employee 10 | 2020-10-09 00:00:00 | 2020-10-09 00:00:00 | [NAME] | 1
 | Employee 10 | 2020-10-08 00:00:00 | 2020-10-08 00:00:00 | [NAME] | 0.25
 | Employee 10 | 2020-09-28 00:00:00 | 2020-09-28 00:00:00 | Vacation | 1
 | Employee 11 | 2021-01-12 00:00:00 | 2021-01-12 00:00:00 | [NAME] | 1
 | Employee 11 | 2020-10-01 00:00:00 | 2020-10-02 00:00:00 | Vacation | 2
 | Employee 16 | 2021-02-10 00:00:00 | 2021-02-11 00:00:00 | [NAME] | 2 | !!!!!!
 | Employee 15 | 2021-04-09 00:00:00 | 2021-04-09 00:00:00 | Unpaid | 1
 | Employee 15 | 2021-04-07 00:00:00 | 2021-04-07 00:00:00 | Unpaid | 1
 | Employee 15 | 2021-04-02 00:00:00 | 2021-04-02 00:00:00 | Unpaid | 1
 | Employee 15 | 2021-03-15 00:00:00 | 2021-03-16 00:00:00 | Unpaid | 2
 | Employee 15 | 2021-02-16 00:00:00 | 2021-02-16 00:00:00 | Unpaid | 1
 | Employee 15 | 2021-02-09 00:00:00 | 2021-02-09 00:00:00 | Unpaid | 1
 | Employee 15 | 2021-01-28 00:00:00 | 2021-01-28 00:00:00 | Unpaid | 1
 | Employee 15 | 2021-01-20 00:00:00 | 2021-01-20 00:00:00 | Unpaid | 0.75 | *Worked 2 Hrs
 | Employee 15 | 2021-01-12 00:00:00 | 2021-01-13 00:00:00 | Unpaid | 2
 | Employee 15 | 2020-12-28 00:00:00 | 2020-12-28 00:00:00 | Unpaid | 1
 | Employee 15 | 2020-12-14 00:00:00 | 2020-12-15 00:00:00 | Unpaid | 2
 | Employee 15 | 2020-11-06 00:00:00 | 2020-11-06 00:00:00 | Unplanned Vacation | 1
 | Employee 15 | 2020-11-05 00:00:00 | 2020-11-05 00:00:00 | Unpaid | 1
 | Employee 15 | 2020-11-02 00:00:00 | 2020-11-04 00:00:00 | Vacation | 3
 | Employee 15 | 2020-10-08 00:00:00 | 2020-10-08 00:00:00 | Unplanned Vacation | 1
 | Employee 15 | 2020-09-21 00:00:00 | 2020-09-21 00:00:00 | Unplanned Vacation | 1
 | Employee 15 | 2020-08-28 00:00:00 | 2020-08-28 00:00:00 | [NAME] | 0.5
 | Employee 15 | 2020-05-14 00:00:00 | 2020-05-14 00:00:00 | Unplanned Vacation | 5 | *Advancement
 | Employee 15 | 2020-02-20 00:00:00 | 2020-02-20 00:00:00 | Unpaid | 1
 | Employee 15 | 2020-02-14 00:00:00 | 2020-02-19 00:00:00 | Vacation | 4
 | Employee 15 | 2020-02-12 00:00:00 | 2020-02-13 00:00:00 | [NAME] | 2
 | Employee 15 | 2020-02-11 00:00:00 | 2020-02-11 00:00:00 | [NAME] | 0.5
 | Employee 2 | 2021-03-15 00:00:00 | 2021-03-15 00:00:00 | Unpaid | 1
 | Employee 2 | 2020-11-20 00:00:00 | 2020-11-20 00:00:00 | Unpaid | 1
 | [NAME] | 2020-03-24 00:00:00 | 2020-03-25 00:00:00 | Vacation
 | [NAME] | 2020-04-07 00:00:00 | 2020-04-09 00:00:00 | Vacation
 | [NAME] | 2020-06-16 00:00:00 | 2020-06-17 00:00:00 | Vacation
 | [NAME] | 2020-07-07 00:00:00 | 2020-07-08 00:00:00 | Vacation
 | [NAME] | 2020-07-14 00:00:00 | 2020-07-15 00:00:00 | Vacation
 | [NAME] | 2020-07-28 00:00:00 | 2020-07-29 00:00:00 | Vacation
 | [NAME] | 2021-11-03 00:00:00 | 2021-11-04 00:00:00 | Vacation
 | [NAME] | 2021-12-08 00:00:00 | 2021-12-10 00:00:00 | Vacation
 | [NAME] | 2021-12-22 00:00:00 | 2021-12-23 00:00:00 | Vacation
 | [NAME] | 2021-01-13 00:00:00 | 2021-01-17 00:00:00 | Vacation
 | [NAME] | 2021-01-20 00:00:00 | 2021-01-24 00:00:00 | Vacation
 | [NAME] | 2021-06-16 00:00:00 | 2021-06-17 00:00:00 | Vacation
 | [NAME] | 2021-06-23 00:00:00 | 2021-06-27 00:00:00 | Vacation
 | [NAME] | 2021-07-28 00:00:00 | 2021-08-01 00:00:00 | Vacation
 | [NAME] | 2021-08-04 00:00:00 | 2021-08-07 00:00:00 | Vacation
 | [NAME] | 2021-08-11 00:00:00 | 2021-08-12 00:00:00 | Vacation