🚀 Excel Formulas Fundamentals — Part 7

📅 Date & Time Functions in Excel Real-World Business Examples

Dates are used in almost every business report. Whether you're tracking employee attendance, calculating customer age, measuring project timelines, or analyzing monthly sales, Excel's date and time functions are essential.

🧠 1. How Excel Stores Dates

Excel stores dates as serial numbers.

For example:

Date Serial Number

01-Jan-1900 1

15-Jun-2026 Stored as a serial number internally

📌 This allows Excel to perform calculations like adding days or finding the difference between dates.

📅 2. TODAY() Function

TODAY() returns the current date.

Syntax: =TODAY()

Example: If today's date is 26-Jun-2026: Result 26-Jun-2026

Use Cases: ✅ Attendance sheets, ✅ Invoice dates, ✅ Daily reports

⏰ 3. NOW() Function

Returns the current date and time.

Syntax: =NOW()

Example: 26-Jun-2026 10:30 AM

Use Cases: Report generation timestamps, Activity logs, Audit tracking

📌 Unlike TODAY(), NOW() includes the time.

🗓️ 4. DATE() Function

Creates a valid date from year, month, and day values.

Syntax: =DATE(year,month,day)

Example: =DATE(2026,6,15) Result 15-Jun-2026

Use Cases: Creating dynamic dates, Financial models, Scheduling reports

📆 5. YEAR() MONTH() & DAY()

These functions extract parts of a date.

YEAR() =YEAR(A2) Result 2026

MONTH() =MONTH(A2) Result 6

DAY() =DAY(A2) Result 15

Business Example: If Order Date = 15-Jun-2026 → You can extract Year → 2026, Month → 6, Day → 15.

This is useful for monthly and yearly reporting.

⏳ 6. Calculate Days Between Two Dates

Example: Start Date End Date → 01-Jun-2026 15-Jun-2026

Formula: =B2-A2 Result 14

📌 Excel automatically returns the number of days.

📊 7. DATEDIF() Function

Calculates the difference between two dates.

Syntax: =DATEDIF(start_date,end_date,unit)

Calculate Years: =DATEDIF(A2,B2,"Y")

Calculate Months: =DATEDIF(A2,B2,"M")

Calculate Days: =DATEDIF(A2,B2,"D")

Real Example: Employee Joining Date 01-Jan-2020, Today's Date 26-Jun-2026

Formula: =DATEDIF(A2,TODAY(),"Y") Result 6 Years

📌 Commonly used to calculate Employee experience, Customer age, Membership duration

🏢 8. NETWORKDAYS()

Calculates working days between two dates. Weekends are automatically excluded.

Syntax: =NETWORKDAYS(start_date,end_date)

Example: =NETWORKDAYS(A2,B2)

Include Holidays: =NETWORKDAYS(A2,B2,D2:D10) where D2:D10 contains holiday dates

Use Cases: ✅ Project planning, ✅ SLA tracking, ✅ Payroll calculations

📈 9. EDATE()

Adds or subtracts months from a date.

Syntax: =EDATE(start_date,months)

Example: =EDATE(A2,3) Returns a date 3 months after the date in A2

📌 Useful for Loan schedules, Subscription renewals, Contract expiry dates

📅 10. EOMONTH()

Returns the last day of a month.

Syntax: =EOMONTH(start_date,months)

Example: =EOMONTH(A2,0) If A2 = 15-Jun-2026 Result 30-Jun-2026

Use Cases: Month-end reports, Financial closing, Billing cycles