| DATE |
Create a valid date from year, month, and day |
year month day |
| DATEDIF |
Get days, months, or years between two dates |
start_date end_date unit |
| DATEVALUE |
Convert a date in text format to a valid date |
date_text |
| DAY |
Get the day as a number (1-31) from a date |
date |
| DAYS |
Get days between dates |
end_date start_date |
| DAYS360 |
Get days between 2 dates in a 360-day year |
start_date end_datemethod |
| EDATE |
Get the same date in future or past months |
start_date months |
| EOMONTH |
Get the last day of the month in future or past months |
start_date months |
| HOUR |
Get the hour as a number (0-23) from a Time |
serial_number |
| ISOWEEKNUM |
Get ISO week number for a given date |
date |
| MINUTE |
Get the minute as a number (0-59) from a time |
serial_number |
| MONTH |
Get the month as a number (1-12) from a date |
date |
| NETWORKDAYS |
Get the number of working days between two dates |
start_date end_dateholidays |
| NETWORKDAYS.INTL |
Get work days between two dates |
start_date end_dateweekend holidays |
| NOW |
Get the current date and time |
|
| SECOND |
Get the Second as a number (0-59) from a Time |
serial_number |
| TIME |
Create a time with hours, minutes, and seconds |
hour minute second |
| TIMEVALUE |
Get a valid time from a text string |
time_text |
| TODAY |
Get the current date |
|
| WEEKDAY |
Get the day of the week as a number |
serial_numberreturn_type |
| WEEKNUM |
Get the week number for a given date |
serial_numreturn_type |
| WORKDAY |
Get a date n working days in the future or past |
start_date daysholidays |
| WORKDAY.INTL |
Get date and working days in future or past |
start_date daysweekend holidays |
| YEAR |
Get the year from a date |
date |
| YEARFRAC |
Get the fraction of a year between two dates |
start_date end_datebasis |
