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