Google Sheets date functions
Date functions in Google Sheets, explained with live examples.
26 date functions in Google Sheets — 0 documented in depth so far, the rest indexed below and landing every week.
All Google Sheets date functions
The full set — deep dives on the way.
- DATE
- Converts a provided year, month, and day into a date.
- DATEDIF
- Calculates the number of days, months, or years between two dates.
- DATEVALUE
- Converts a provided date string in a known format to a date value.
- DAY
- Returns the day of the month that a specific date falls on, in numeric format.
- DAYS
- Returns the number of days between two dates.
- DAYS360
- Returns the difference between two days based on the 360 day year used in some financial interest calculations.
- EDATE
- Returns a date a specified number of months before or after another date.
- EOMONTH
- Returns a date representing the last day of a month which falls a specified number of months before or after another date.
- EPOCHTODATE
- Converts a Unix epoch timestamp in seconds, milliseconds, or microseconds to a datetime in UTC.
- HOUR
- Returns the hour component of a specific time, in numeric format.
- ISOWEEKNUM
- Returns the number of the ISO week of the year where the provided date falls.
- MINUTE
- Returns the minute component of a specific time, in numeric format.
- MONTH
- Returns the month of the year a specific date falls in, in numeric format.
- NETWORKDAYS
- Returns the number of net working days between two provided days.
- NETWORKDAYS.INTL
- Returns the number of net working days between two provided days excluding specified weekend days and holidays.
- NOW
- Returns the current date and time as a date value.
- SECOND
- Returns the second component of a specific time, in numeric format.
- TIME
- Converts a provided hour, minute, and second into a time.
- TIMEVALUE
- Returns the fraction of a 24-hour day the time represents.
- TODAY
- Returns the current date as a date value.
- WEEKDAY
- Returns a number representing the day of the week of the date provided.
- WEEKNUM
- Returns a number representing the week of the year where the provided date falls.
- WORKDAY
- Calculates the end date after a specified number of working days.
- WORKDAY.INTL
- Calculates the date after a specified number of workdays excluding specified weekend days and holidays.
- YEAR
- Returns the year specified by a given date.
- YEARFRAC
- Returns the number of years, including fractional years, between two dates using a specified day count convention.
More Google Sheets function categories