Type in Google’s function list
Date functions
Functions that read, build or measure dates and times. Google prints 26 Date function(s) in its Google Sheets function list.
| Function | Syntax as printed | Description from Google Docs Editors Help |
|---|---|---|
| DATE | DATE(year, month, day) | Converts a provided year, month, and day into a date. |
| DATEDIF | DATEDIF(start_date, end_date, unit) | Calculates the number of days, months, or years between two dates. |
| DATEVALUE | DATEVALUE(date_string) | Converts a provided date string in a known format to a date value. |
| DAY | DAY(date) | Returns the day of the month that a specific date falls on, in numeric format. |
| DAYS | DAYS(end_date, start_date) | Returns the number of days between two dates. |
| DAYS360 | DAYS360(start_date, end_date, [method]) | Returns the difference between two days based on the 360 day year used in some financial interest calculations. |
| EDATE | EDATE(start_date, months) | Returns a date a specified number of months before or after another date. |
| EOMONTH | EOMONTH(start_date, months) | Returns a date representing the last day of a month which falls a specified number of months before or after another date. |
| EPOCHTODATE | EPOCHTODATE(timestamp, [unit]) | Converts a Unix epoch timestamp in seconds, milliseconds, or microseconds to a datetime in UTC. |
| HOUR | HOUR(time) | Returns the hour component of a specific time, in numeric format. |
| ISOWEEKNUM | ISOWEEKNUM(date) | Returns the number of the ISO week of the year where the provided date falls. |
| MINUTE | MINUTE(time) | Returns the minute component of a specific time, in numeric format. |
| MONTH | MONTH(date) | Returns the month of the year a specific date falls in, in numeric format. |
| NETWORKDAYS | NETWORKDAYS(start_date, end_date, [holidays]) | Returns the number of net working days between two provided days. |
| NETWORKDAYS.INTL | NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays]) | Returns the number of net working days between two provided days excluding specified weekend days and holidays. |
| NOW | NOW() | Returns the current date and time as a date value. |
| SECOND | SECOND(time) | Returns the second component of a specific time, in numeric format. |
| TIME | TIME(hour, minute, second) | Converts a provided hour, minute, and second into a time. |
| TIMEVALUE | TIMEVALUE(time_string) | Returns the fraction of a 24-hour day the time represents. |
| TODAY | TODAY() | Returns the current date as a date value. |
| WEEKDAY | WEEKDAY(date, [type]) | Returns a number representing the day of the week of the date provided. |
| WEEKNUM | WEEKNUM(date, [type]) | Returns a number representing the week of the year where the provided date falls. |
| WORKDAY | WORKDAY(start_date, num_days, [holidays]) | Calculates the end date after a specified number of working days. |
| WORKDAY.INTL | WORKDAY.INTL(start_date, num_days, [weekend], [holidays]) | Calculates the date after a specified number of workdays excluding specified weekend days and holidays. |
| YEAR | YEAR(date) | Returns the year specified by a given date. |
| YEARFRAC | YEARFRAC(start_date, end_date, [day_count_convention]) | Returns the number of years, including fractional years, between two dates using a specified day count convention. |
Source: Google Docs Editors Help, “Google Sheets function list” (support.google.com/docs/table/25273), data fetched 28 September 2026. Data month: September 2026. Every function name in Google’s list is placed under one type; a function carries the type the list prints for it.