Dynamic Leave Tracker - Google Sheets

Description
Validations:
Please modify the days of the weekends by editing the values in the highlighted cells. Additionally, you have the option to add holidays, which will be displayed on other sheets. Ensure that you update validations to maintain a smooth workflow. Any changes made to validations will automatically be applied to other sheets as well. You can add up to 11 different types of "Leave" as needed; currently, there are three types of allocated leaves available. Lastly, you can adjust the Year and Probation Period to suit your requirements.

Employee Setup:
On this sheet, you can input the employee's details, including their joining date. When you update the probation period on the previous sheet, all calculations for other columns, such as confirmation date, job status, and allocated leaves for the rest of the year, will be automatically done.

Yearly View:
This sheet provides a clear overview of data for all employees throughout the year.

Monthly View:
On this sheet, you can track the leaves taken by employees on a monthly and yearly basis. It offers two validations for the month and department, providing a clear view of the information.

Emp. Leave Database:
This sheet allows you to input the leave data for employees. An useful feature is the ability to enter multiple leave periods, starting from 01/01/2024 to 10/01/2024, with all calculations automatically considering only weekdays.

Individual Leaves View:
On this sheet, you have the opportunity to view the individual employee details throughout the whole year, as well as the details for each department.

Please note that this is a template worksheet. If it does not meet your needs 100%, and you are unable to customize it yourself, let me know and we will provide a quote to develop the customisations you need to get you exactly what you want in your Appointment Scheduler.

Please look at the sheet:
https://docs.google.com/spreadsheets/d/e/2PACX-1vThsOkBCxOZ_8rr7VyrLDdvnX16KIaobqEpBiP9md09i0UgDuiJX2qUkIIIyC6RuFJR6nPQF9u7P11k/pubhtml