Date & time
DATEDIF function
Years, months or days between two dates. DATEDIF works in Sheets with the usual arguments and results, on cells and on live data from the tools you connect.
Syntax
=DATEDIF(start_date, end_date, unit) | Argument | Use |
|---|---|
start_date | required |
end_date | required |
unit | required |
On live data
In Sheets, DATEDIF sits next to live data from a connected tool: =data.orders.sum(total) totals a table, =list.orders(customer) spills a column's distinct values, and a linked table column such as table.orders[Total] is a range any function accepts.
More date & time functions
DATEDate from parts (yyyy-mm-dd)EOMONTHLast day of the month N months awayMONTHMonth of a date (1-12)NETWORKDAYSWorking days between two datesYEARYear of a dateDATEVALUEDate text as a serial numberDAYDay of the month (1-31)DAYSNumber of days between two datesDAYS360Days between dates on a 360-day yearEDATESame day N months before or after a dateHOURHour of a time (0-23)ISOWEEKNUMISO 8601 week number of a date
Spreadsheet formulas on live business data
Sheets evaluates 491 spreadsheet functions, on cells and on data read live from your tools.