Syntax
DateDiff(StartDateTime, EndDateTime [, Units])Examples
=DateDiff(Date(2026, 1, 1), Date(2026, 10, 23), TimeUnit.Days)295
Maker notes
- Returns whole units only, with no fractions. Days are the default unit.
DateDiff
Returns the difference between two date/time values in the units you choose.