HIDDEN FUNCTION
Goal: Calculate the difference between Jan 1, 2020 and Apr 1, 2023.
DATEDIF finds the duration in Years, Months, or Days.
Start: 2020-01-01
End: 2023-04-01
Ready...
💻 Formula Structure
=DATEDIF(start_date, end_date, unit)
- 1. Start/End: The date range.
- 2. Unit: "Y" (Years), "M" (Months), "D" (Days).
- 3. Remainder: "YM" (Months excluding years), "MD" (Days excluding months).
⚠️ The "Ghost" Function
🚫 No Tooltips
When you type =DATEDIF(, Excel will not show the usual helper tooltip. You must memorize the syntax!
🚫 "MD" Bug
Avoid the "MD" unit (Days excluding Months). It has a known calculation bug in Excel. Use simple subtraction for days if needed.