🎯 Mini Practice Project

Create Employee_Attendance.xlsx

Columns: Employee, Joining Date, Experience (Years), Working Days

Tasks:

✅ Show today's date =TODAY()

✅ Show current date & time =NOW()

✅ Extract joining year =YEAR(B2)

✅ Calculate employee experience =DATEDIF(B2,TODAY(),"Y")

✅ Calculate working days in a project =NETWORKDAYS(C2,D2)

🏆 End of Part 7

After completing this lesson, you should be able to:

✅ Work confidently with dates and times

✅ Use TODAY() and NOW()

✅ Extract year, month, and day

✅ Calculate date differences using DATEDIF()

✅ Calculate working days using NETWORKDAYS()

✅ Build real-world HR, payroll, finance, and project tracking reports

➡️ Double Tap ❤️ For Part-8