Spreadsheet: 761788d1641223891-employee-attendance-tracker-starting-september-for-12-months-calendar-sample-workbook
Sheet: Employee Leave Tracker

 |  |  | PLEASE NOTE:  The start day is the first day of leave/sickness and the end date is the last day of leave/sickness and NOT the day that they retun to work
 | Employee Name | Start Date | End Date | Month | Type of Leave | Days | Entered By | Documentation Complete | Comments
 | [NAME] (27+4.5) | 2016-04-25 00:00:00 | 2016-04-29 00:00:00 | April | Annual Leave | 5 | [NAME] | Yes
 | [NAME] (27+4.5) | 2016-08-14 00:00:00 | 2016-08-14 00:00:00 | August | Annual Leave | 1 | [NAME] | Yes
 | [NAME] (27+4.5) | 2016-09-15 00:00:00 | 2016-09-19 00:00:00 | September | Annual Leave | 3 | [NAME] | Yes
 | [NAME] (33+1) | 2016-07-11 00:00:00 | 2016-07-15 00:00:00 | July | Annual Leave | 5 | [NAME] | Yes
 | [NAME] (33+1) | 2016-09-12 00:00:00 | 2016-09-12 00:00:00 | September | Annual Leave | 1 | [NAME] | Yes
 | [NAME] (33) | 2016-04-15 00:00:00 | 2016-04-15 00:00:00 | April | Annual Leave | 0.5 | [NAME] | Yes
 | [NAME] (33) | 2016-05-26 00:00:00 | 2016-05-26 00:00:00 | May | Annual Leave | 0.5 | [NAME] | Yes
 | [NAME] (33) | 2016-06-20 00:00:00 | 2016-06-27 00:00:00 | June | Annual Leave | 6 | [NAME] | Yes
 | [NAME] (33) | 2016-08-31 00:00:00 | 2016-08-31 00:00:00 | August | Annual Leave | 0.5 | [NAME] | Yes
 | [NAME] (33) | 2016-10-11 00:00:00 | 2016-10-19 00:00:00 | October | Annual Leave | 7 | [NAME] | Yes
 | [NAME] (33+1) | 2016-06-07 00:00:00 | 2016-06-08 00:00:00 | June | Time Owing | 2 | [NAME] | Yes
 | [NAME] (29+1) | 2016-04-15 00:00:00 | 2016-04-15 00:00:00 | April | Annual Leave | 1 | [NAME] | Yes
 | [NAME] (29+1) | 2016-04-12 00:00:00 | 2016-04-12 00:00:00 | April | Annual Leave | 1 | [NAME] | Yes
 | [NAME] (29+1) | 2016-05-27 00:00:00 | 2016-05-27 00:00:00 | May | Annual Leave | 1 | [NAME] | Yes
 | [NAME] (29+1) | 2016-07-13 00:00:00 | 2016-07-13 00:00:00 | July | Annual Leave | 1 | [NAME] | Yes
 | [NAME] (29+1) | 2016-07-22 00:00:00 | 2016-07-29 00:00:00 | July | Annual Leave | 6 | [NAME] | Yes
 | [NAME] (29+1) | 2016-08-01 00:00:00 | 2016-08-01 00:00:00 | August | Annual Leave | 1 | [NAME] | Yes
 | [NAME] (29+1) | 2016-08-04 00:00:00 | 2016-08-05 00:00:00 | August | Annual Leave | 2 | [NAME] | Yes
 | [NAME] (29+1) | 2016-12-19 00:00:00 | 2016-12-23 00:00:00 | December | Annual Leave | 5 |  | Yes
 | [NAME] (29+1) | 2016-06-02 00:00:00 | 2016-06-02 00:00:00 | June | Annual Leave | 1 |  | Yes
 | [NAME] (29+1) | 2016-06-06 00:00:00 | 2016-06-06 00:00:00 | June | Annual Leave | 1 |  | Yes
 | [NAME] (29+1) | 2016-06-09 00:00:00 | 2016-06-09 00:00:00 | June | Annual Leave | 1 |  | Yes
 | [NAME] (29+1) | 2016-06-23 00:00:00 | 2016-06-23 00:00:00 | June | Annual Leave | 1 |  | Yes
 | [NAME] (29+1) | 2016-06-14 00:00:00 | 2016-06-14 00:00:00 | June | Annual Leave | 0.5 |  | Yes
 | [NAME] (29+1) | 2016-06-30 00:00:00 | 2016-06-30 00:00:00 | June | Annual Leave | 1 |  | Yes
 | [NAME] (29+1) | 2016-07-07 00:00:00 | 2016-07-07 00:00:00 | June | Annual Leave | 1 |  | Yes
 | [NAME] (29+1) | 2016-07-21 00:00:00 | 2016-07-21 00:00:00 | July | Annual Leave | 1 |  | Yes
 | [NAME] (29+1) | 2016-08-19 00:00:00 | 2016-08-19 00:00:00 | August | Annual Leave | 1 |  | Yes
 | [NAME] (29) | 2016-06-30 00:00:00 | 2016-06-30 00:00:00 | June | Time Owing | 1 |  | Yes
 | [NAME] (29) | 2016-07-01 00:00:00 | 2016-07-01 00:00:00 | July | Time Owing | 1 |  | Yes
 | [NAME] (29) | 2016-08-01 00:00:00 | 2016-08-05 00:00:00 | August | Annual Leave | 5 |  | Yes
 | [NAME] (29) | 2016-08-22 00:00:00 | 2016-08-26 00:00:00 | August | Annual Leave | 5 |  | Yes
 | [NAME] (29) | 2016-10-24 00:00:00 | 2016-10-28 00:00:00 | October | Annual Leave | 5 |  | Yes
 | [NAME] (29) | 2016-11-16 00:00:00 | 2016-11-18 00:00:00 | November | Annual Leave | 3 |  | Yes
 | [NAME] (27+4.5) | 2016-10-13 00:00:00 | 2016-10-14 00:00:00 | October | [NAME] | 2
 | [NAME] (27+4.5) | 2016-12-01 00:00:00 | 2016-12-01 00:00:00 | December | Annual Leave | 1
 | [NAME] (27+4.5) | 2017-01-03 00:00:00 | 2017-01-03 00:00:00 | January | Annual Leave | 1
 | [NAME] (27+4.5) | 2017-02-05 00:00:00 | 2017-02-05 00:00:00 | February | Annual Leave | 1
 | [NAME] (27+4.5) | 2017-03-06 00:00:00 | 2017-03-06 00:00:00 | March | [NAME] | 1
 | [NAME] (27+4.5) | 2016-10-16 00:00:00 | 2016-10-16 00:00:00 | October | Time Owing | 1