Excel Functions | EDATE, EOMONTH & DATEDIF Explained

Excel Date Hacks to Save You Hours ⏳

1. EDATE
=EDATE(start_date, months)
Returns a date that is n months before or after a start date.

+ve months = future date

-ve months = past date
👉 Example: =EDATE(A1, 2) shifts dates by full months.
2. EOMONTH
=EOMONTH(start_date, months)
Returns the last day of the month, n months before or after a start date.

0 → current month’s end

1 → next month’s end
👉 Example: =EOMONTH(A1, 0) jumps to month-end dates.
3. DATEDIF
=DATEDIF(start_date, end_date, unit)
Calculates the difference between two dates in years, months, or days.

"Y" → complete years

"M" → complete months

"D" → days

"YM" → months ignoring years

"MD" → days ignoring months/years
👉 Example: =DATEDIF(A1, A2, "Y")

Видео Excel Functions | EDATE, EOMONTH & DATEDIF Explained канала Prakash_Info_Point