📊 Excel Formulas — Part 6

This part focuses on Date & Time formulas — essential for reporting, deadlines, ageing analysis, trends, and time-based calculations.

1️⃣ TODAY

Returns the current date.

=TODAY()

• Example: Automatically display today's date.

2️⃣ NOW

Returns the current date and time.

=NOW()

• Example: Track when a workbook was last recalculated.

3️⃣ DATE

Creates a date from year, month, and day.

=DATE(2026,9,24)

• Result: 24-Sep-2026

4️⃣ YEAR

Extracts the year from a date.

=YEAR(A2)

• Example: 24-Sep-2026 → 2026

5️⃣ MONTH

Extracts the month number.

=MONTH(A2)

• Example: 24-Sep-2026 → 9

6️⃣ DAY

Extracts the day of the month.

=DAY(A2)

• Example: 24-Sep-2026 → 24

7️⃣ EOMONTH

Returns the last day of a month.

=EOMONTH(A2,0)

• If A2 is 24-Sep-2026 → Result: 30-Sep-2026

• You can also move between months:

• =EOMONTH(A2,1) → Last day of next month

8️⃣ DATEDIF

Calculates the difference between two dates.

=DATEDIF(A2,B2,"Y")

• Returns the number of complete years.

Other units:

• "Y" → Years

• "M" → Months

• "D" → Days

Example:

• =DATEDIF(A2,B2,"D") → Number of days between the dates.

9️⃣ DAYS

Returns the number of days between two dates.

=DAYS(B2,A2)

• Example:

• Start Date → 01-Sep-2026

• End Date → 24-Sep-2026

• Result → 23

🔟 NETWORKDAYS

Calculates the number of working days between two dates, excluding weekends.

=NETWORKDAYS(A2,B2)

• You can also exclude holidays:

• =NETWORKDAYS(A2,B2,E2:E10)

🧠 Quick Reference

• TODAY() → Current date

• NOW() → Current date + time

• DATE() → Create a date

• YEAR() → Extract year

• MONTH() → Extract month

• DAY() → Extract day

• EOMONTH() → Last day of month

• DATEDIF() → Difference between dates

• DAYS() → Number of days between dates

• NETWORKDAYS() → Working days between dates

💡 Practice

• Employee → Joining Date → End Date

• Rahul → 10-Jan-2022 → 24-Sep-2026

• Priya → 15-Mar-2023 → 24-Sep-2026

• Amit → 20-Jul-2024 → 24-Sep-2026

• Neha → 05-Feb-2025 → 24-Sep-2026

❤️ Double Tap & React For Part 7!