Date & Time

Built-in functions › Spreadsheet formulas › Date & Time

23 functions in this category.

Date & Time

Function	What it does
date	Construct a date serial number from year, month, day.
datedif	Difference between two dates in a chosen unit.
datevalue	Parse a date string into a serial date number.
day	Day-of-month component of a date (1–31).
days	Number of days between two dates.
days360	Number of days between two dates using a 360-day year (30-day months).
edate	Date offset by a number of months.
eomonth	Last day of the month some months from the start date.
hour	Hour component of a time (0–23).
isoweeknum	ISO 8601 week of the year.
minute	Minute component of a time (0–59).
month	Month component of a date (1–12).
networkdays	Number of working days between two dates.
now	Current date and time as a serial date-time number.
second	Second component of a time (0–59).
time	Construct a time fraction from hour, minute, second.
timevalue	Parse a time string into a fraction of a day.
today	Today’s date as a serial date number.
weekday	Day of the week.
weeknum	Week of the year.
workday	Date a number of workdays after a given start.
year	Year component of a date.
yearfrac	Fraction of a year between two dates.