Now combine the functions into practical Excel projects.
Project 1 — Age Calculator
|
Name |
DOB |
As On Date |
Age |
|
Amit |
15-Mar-1995 |
28-Sep-2026 |
|
|
Neha |
10-Jul-2000 |
28-Sep-2026 |
|
|
Rahul |
22-Jan-1988 |
28-Sep-2026 |
Formula:
=DATEDIF(B2,C2,”Y”)
Project 2 — Employee Experience Calculator
|
Employee |
Joining Date |
As On Date |
Experience |
|
Amit |
10-Jun-2018 |
28-Sep-2026 |
|
|
Neha |
15-Jan-2021 |
28-Sep-2026 |
|
|
Rahul |
01-Apr-2016 |
28-Sep-2026 |
Calculate:
- Complete Years
- Complete Months
- Total Days
Project 3 — Attendance Tracker
Create:
Date | Employee | Day | Week No. | Status
Use:
=WEEKDAY(A2,2)
=WEEKNUM(A2)
=NETWORKDAYS(StartDate,EndDate,Holidays)
Tasks:
- Identify weekdays and weekends.
- Calculate working days.
- Exclude holidays.
- Calculate attendance percentage.
Project 4 — Due Date Calculator
Create:
|
Task |
Start Date |
Working Days |
Due Date |
|
Project A |
28-Sep-2026 |
10 |
|
|
Project B |
01-Oct-2026 |
15 |
|
|
Project C |
05-Oct-2026 |
20 |
Formula:
=WORKDAY(B2,C2)
With holidays:
=WORKDAY(B2,C2,$H$2:$H$5)
Also calculate month-end:
=EOMONTH(B2,0)