Workbook Functions: Date & 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