Workbook Functions: Date and Time
DATE(year, month, day)
Serial number of the supplied date, where year is a number up to 9999 and the month between 1 and 12.
See also: DATEVALUE, DAY, MONTH, NOW, TIMEVALUE, TODAY, YEAR
DATEVALUE(text)
Serial number of a date supplied in text format (e.g. "3/6/1994") up to the year 9999.
See also: NOW, TIMEVALUE, TODAY
DAY(serial number)
Day of the month that corresponds to the date represented by the given argument, be it a serial number (e.g. 34399) or a text (e.g. "21-06-1994").
See also: NOW, HOUR, MINUTE, MONTH, SECOND, TODAY, WEEKDAY, YEAR
DAY360(start_date, end_date, [method])
Number of days between two dates based on a 360 day year (twelve 30 day months). If method = true then the European system is used. If method = false or omitted then the US system is used.
HOUR(serial number)
Hour component of the specified time (given as serial number) in 24 hour format.
See also: DAY, MINUTE, MONTH, NOW, SECOND, WEEKDAY, YEAR
MINUTE(serial number)
Minute component of the specified time (given as serial number) as an integer between 0 and 59.
See also: DATE, DAY, HOUR, MONTH, NOW, SECOND, WEEKDAY, YEAR
SECOND(serial number)
Returns the second that corresponds to the specified date.
See also: DAY, HOUR, MINUTE, MONTH, NOW, WEEKDAY, YEAR
TIME(0<hour<23, 0<minute<59, 0<second<59)
Returns the serial number for the specified time.
See also: HOUR, MINUTE, NOW, SECOND, TIMEVALUE
TIMEVALUE(text)
Returns the serial number for the supplied time given in text format.
See also: HOUR, MINUTE, NOW, SECOND, TIME
TODAY()
Returns the current date as a serial number.
See also: DATE, DAY, NOW
WEEKDAY(serial number)
Day of the week that corresponds to the supplied date: Sunday is 1 and 7 is Saturday.
See also: DAY, NOW, TEXT, TODAY
YEAR(serial number)
Year that corresponds to the supplied date.
See also: DAY, NOW, HOUR, MINUTE, MONTH, SECOND, TODAY, WEEKDAY