How to easily create Leave tracking in Excel

Leave Tracker is a regular task to keep track of employee leave days. With just one Excel file you can track employee leave by day, by month and use this file for different years.
Sample file https://bit.ly/3E2uATh

00:02 Intro
00:30 Set up years to track vacation days
00:52 Set the days of the month
01:20 Set the days of the week
02:03 Absence types drop down list
02:34 Each type of absence has different colors.
04:08 Total number of vacation days in a month for an employee
04:52 Total sick ...