Project: Employee Attendance & Deadline Tracker
Create the following worksheet:
|
Employee |
Joining Date |
Today |
Service Years |
Service Months |
Working Days |
Deadline |
|
Amit |
15-Jan-2022 |
|||||
|
Neha |
20-Mar-2023 |
|||||
|
Rahul |
10-Jul-2024 |
|||||
|
Priya |
05-Feb-2025 |
|||||
|
Simran |
18-Jun-2025 |
Required Formulas
Today’s Date
=TODAY()
Service Years
=DATEDIF(B2,C2,”Y”)
Service Months
=DATEDIF(B2,C2,”M”)
Working Days
=NETWORKDAYS(B2,C2)
Deadline — 10 Working Days
=WORKDAY(B2,10)
Additional Time Section
|
Employee |
Login |
Logout |
Working Hours |
|
Amit |
09:15 AM |
06:00 PM |
|
|
Neha |
09:30 AM |
05:45 PM |
|
|
Rahul |
10:00 AM |
07:00 PM |
Working Hours:
=C2-B2
Format as:
[h]:mm
Final Challenge
Create a professional Employee Attendance & Deadline Dashboard showing:
- Current date
- Employee joining date
- Service period
- Working days
- Project deadline
- Login time
- Logout time
- Total working hours