Skip to main content
Mail a PDF copy of this page to:
(Your email address will not be added to a mailing list)
Show menu Show menu

Date and time functions

To format a spreadsheet column for date, time or date-time input, see How to enter dates.

DATE(dnr) Serial date number to string

DATEFRAC(date) Returns a fractional year-number

DATEVALUE(str) String to serial date number

DAY(date) Day of date

DAYNAME(date[,languagecode]) Name of the day of date

MONTH(date) Month of date

MONTHNAME(date[,languagecode]) Name of the month of date

NOW() Current date and time

TIME(tnr) Converts the serial time number tnr to a time string (hh:mm)

TIMEFRAC(time) Returns a fractional time-number

TIMEVALUE(str) Converts a time string (in "hh:mm" format) to a serial time number

TODAY() Today's date

WEEKDAY(date) Weekday number of date

WEEKNUM(date) Week of the year of date

YEAR(date) Year of date

See also