| YEAR | Returns the year of the specified date | YEAR(date) |
| DATE | Returns a date assembled from 3 numbers | DATE(year, month, day) |
| DATEVALUE | Converts a date entered in a regular format into a number | DATEVALUE(date) |
| EDATE | Returns the date that is a certain number of months away from the start date as a number | EDATE(start_date, months) |
| DAY | Returns the day of the specified date | DAY(date) |
| YEARFRAC | Calculates the number of years, including fractional years, between the dates as a decimal fraction | YEARFRAC(start_date, end_date, [calculation_method]) |
| EOMONTH | Returns the last date of the month that is a certain number of months away from the start date as a number | EOMONTH(start_date, months) |
| MONTH | Returns the month of the specified date | MONTH(date) |
| MINUTE | Returns minutes from 0 to 59 of the specified time | MINUTE(time) |
| ISOWEEKNUM | Returns the ISO week number of the year for the specified date | ISOWEEKNUM(date) |
| DATEDIF | Calculates the number of complete years, months, or days between two dates | DATEDIF(start_date, end_date, unit) |
| TODAY | Returns the current date | TODAY() |
| NOW | Returns the current date and time | NOW() |
| HOUR | Returns hours from 0 to 23 of the specified time | HOUR(time) |