I will create an excel attendance and leave tracker

Features Included:

1. Employee Profiles Tab:

• Employee details such as:
• Employee ID, Name, Contact Number, Hired Date, Birth Date (with auto-calculated age).
• Job Title, Department, Reporting Manager.
• Type of Employment (e.g., full-time, part-time).
• Photo integration for personalized records.
• Regular Working Hours, Monthly Salary, Blood Group, Leave Entitlement, and Resignation Date.
• "Still Active" dropdown to distinguish current employees from resigned ones.

1. Monthly Leave Tracker Tabs:

• Dedicated tab for each month to track employee leave types (e.g., sick leave, annual leave, etc.).
• Automatic leave accumulation and balance updates at the end of each month.
• Alerts for low leave balances or negative balances.

1. Dynamic Employee Detail Card:

• Auto-generated employee summary card using a simple Employee ID dropdown.
• Displays key details:
• Employee ID, Name, Contact No.
• Department, Job Title, and Reporting Manager.
• Hired Date, Age, Birth Date, Blood Group, and Current Status (active or resigned).