Master Excel Date Formulas

Learn to calculate dates, find differences, add months, and manipulate dates in Excel with formulas like TODAY, DATEDIF, EDATE, and more.

Try AutoExel Free See Examples

What are Date Formulas in Excel?

Excel date formulas allow you to perform calculations on dates, find differences between dates, add or subtract time periods, and extract date components (day, month, year).

The main date formulas include TODAY, NOW, DATE, DATEDIF, EDATE, EOMONTH, YEAR, MONTH, DAY, WEEKDAY, and NETWORKDAYS.

Main Date Formulas

TODAY / NOW

Returns the current date or date+time

=TODAY()
=NOW()

Example: TODAY() → 12/17/2025, NOW() → 12/17/2025 10:30 AM

DATEDIF

Calculates difference between two dates

=DATEDIF(A1, B1, "D")
=DATEDIF(A1, B1, "M")
=DATEDIF(A1, B1, "Y")

D=days, M=months, Y=years

EDATE

Adds or subtracts months from a date

=EDATE(A1, 3)

Example: A1=01/15/2025 → Result: 04/15/2025 (adds 3 months)

EOMONTH

Returns the last day of the month

=EOMONTH(A1, 0)

Example: A1=01/15/2025 → Result: 01/31/2025

YEAR / MONTH / DAY

Extracts components from a date

=YEAR(A1)
=MONTH(A1)
=DAY(A1)

Example: A1=12/17/2025 → YEAR: 2025, MONTH: 12, DAY: 17

NETWORKDAYS

Calculates working days between dates

=NETWORKDAYS(A1, B1)

Example: Excludes weekends and (optionally) holidays

Practical Examples

Calculate Age

=DATEDIF(A1, TODAY(), "Y")

A1=01/15/1990 → Result: 35 years

Calculate Deadline (30 days from today)

=TODAY() + 30

Result: Current date + 30 days

Check if Date is in Current Month

=AND(MONTH(A1)=MONTH(TODAY()), YEAR(A1)=YEAR(TODAY()))

Result: TRUE or FALSE

Tired of Manual Date Calculations?

AutoExel analyzes your date data and automatically applies the right formulas. Save hours of work!

Try AutoExel Free