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 |