Date and time functions

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

DATEVALUE String to serial date number

The function DATEVALUE(str) returns the serial date number for the date expressed in the string str.

DATE Serial date number to string

DATE(dnr) returns the date corresponding with the serial date number dnr expressed as a string.

DATEFRAC Fractional year-number

DATEFRAC(date) converts date into a fractional year-number. The integer part of this number is the year, and the decimal fraction ranges from 0.0 to 0.99..., representing the dates 01 Jan to 31 Dec.

DAY Day function

DAY(date) returns the day of the month of date. Date can either be a serial date number or a date string.

DAYNAME Day name function

DAYNAME(date) returns the name of the day of date. Date can either be a serial date number or a date string.

MONTH Month function

MONTH(date) returns the month of the year of date. Date can either be a serial date number or a date string.

MONTHNAME Month name function

MONTHNAME(date) returns the name of the month of date. Date can either be a serial date number or a date string.

TIMEVALUE String to serial time number

TIMEVALUE(str) converts a time string (in "hh:mm" format) to a serial time number. A serial time number is a number ranging from 0.00 to 1.00 representing the time 0:00 to 24:00.

TIME Serial time number to string

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

TIMEFRAC Fractional time-number

TIMEFRAC(time) converts time into a fractional time-number. The integer part of this number is the hour, and the decimal fraction ranges from 0.0 to 0.99, representing the minutes 0:00 to 0:59.

TODAY Today's date

The function TODAY() takes no argument and returns today's date. Note that the value of this function is not fixed, so if you use this function in a file and you reload this file the next day, the function will return the new date.

WEEKNUM Week number function

WEEKNUM(date) returns the number of the week of the year of date. Date can either be a serial date number or a date string.

WEEKDAY Weekday number function

WEEKDAY(date) returns the weekday number of date. Days are numbered from Monday (=1) to Sunday (=7).

YEAR Year function

YEAR(date) returns the year of date. Date can either be a serial date number or a date string.

See also

• Spreadsheet: Introduction
• Operators
• Relative and absolute cell addresses
• Mathematical functions
• Statistical functions
• Statistical functions on variables
• String functions
• Logical functions
• Miscellaneous functions