Google Sheets date functions
Date functions in Google Sheets, explained with live examples.
26 date functions in Google Sheets — 26 documented in depth so far, the rest indexed below and landing every week.
Documented date functions
Syntax, examples, and the equivalent — ready now.
- DATEConverts a provided year, month, and day into a date.DateExcel
- DATEDIFCalculates the number of days, months, or years between two dates.DateExcel
- DATEVALUEConverts a provided date string in a known format to a date value.DateExcel
- DAYReturns the day of the month that a specific date falls on, in numeric format.DateExcel
- DAYSReturns the number of days between two dates.DateExcel
- DAYS360Returns the difference between two days based on the 360 day year used in some financial interest calculations.DateExcel
- EDATEReturns a date a specified number of months before or after another date.DateExcel
- EOMONTHReturns a date representing the last day of a month which falls a specified number of months before or after another date.DateExcel
- EPOCHTODATEConverts a Unix epoch timestamp in seconds, milliseconds, or microseconds to a datetime in UTC.DateNo Excel equivalent
- HOURReturns the hour component of a specific time, in numeric format.DateExcel
- ISOWEEKNUMReturns the number of the ISO week of the year where the provided date falls.DateExcel
- MINUTEReturns the minute component of a specific time, in numeric format.DateExcel
- MONTHReturns the month of the year a specific date falls in, in numeric format.DateExcel
- NETWORKDAYSReturns the number of net working days between two provided days.DateExcel
- NETWORKDAYS.INTLReturns the number of net working days between two provided days excluding specified weekend days and holidays.DateExcel
- NOWReturns the current date and time as a date value.DateExcel
- SECONDReturns the second component of a specific time, in numeric format.DateExcel
- TIMEConverts a provided hour, minute, and second into a time.DateExcel
- TIMEVALUEReturns the fraction of a 24-hour day the time represents.DateExcel
- TODAYReturns the current date as a date value.DateExcel
- WEEKDAYReturns a number representing the day of the week of the date provided.DateExcel
- WEEKNUMReturns a number representing the week of the year where the provided date falls.DateExcel
- WORKDAYCalculates the end date after a specified number of working days.DateExcel
- WORKDAY.INTLCalculates the date after a specified number of workdays excluding specified weekend days and holidays.DateExcel
- YEARReturns the year specified by a given date.DateExcel
- YEARFRACReturns the number of years, including fractional years, between two dates using a specified day count convention.DateExcel
More Google Sheets function categories