deepcalc
DocsDATEDIF

DATEDIF

View as markdown/docs/functions/datedif.md Ask Claude about this pageOpens Claude with this page's address

Calculates difference between two dates.

  • Excel: Not checked yet
  • Google Sheets: Not checked yet
  • Returns: Number

Examples

=DATEDIF(DATE(2020,1,1), DATE(2026,7,27), "Y")
Result 6

Syntax

DATEDIF(start_date, end_date, unit)
start_date
number required
end_date
number required
unit
text required

Errors

#VALUE!
=DATEDIF(DATE(2026,1,15), DATE(2026,1,15), 2)
DATECreates date from year, month, day. DATEVALUEConverts date text to serial number. DAYReturns day of month from date. DAYSReturns number of days between two dates. DAYS360Returns days between dates on 360-day year. EDATEReturns date shifted by given months.