DATE

---

Name

Date

Description

Returns the serial value for a particular date.

Syntax

DATE(Year, Month, Day)

Remarks

The arguments are as follows:

Argument	Description
Year	A four-digit number from 1900 to 9999.
Month	A number representing the month of the year. If Month is greater than 12, then Month increments by the number of months over 12 and the year advances, if needed. For example, DATE(2000,16,2) returns the serial value representing April 2, 2001.
Day	A number representing the day of the month. If Day is greater than the number of days in the specified month, then Day increments that number of days from the first day of the next month. For example, DATE(2000,1,35) returns the serial value representing February 4, 2000.

Spread's calc engine processes dates as a numeric value in the form x.y, where x is the "number of days since December 30, 1899" and y is the fraction of day. Numbers to the left represent the date, which is the value that the DATE function returns. Use the TIME function to return the serial value for the time value (the fraction of a day).

Date values are based on the number of days elapsed since December 30, 1899, which has a date serial value of Day 0. For example, December 31, 1899 has a date serial value of 1. Date values prior to December 30, 1899 have negative date serial values. For example, the date value December 29, 1899 has a date serial value of –1.

See also DAY, HOUR, MINUTE, MONTH, NOW, SECOND, TIME, TODAY, WEEKDAY, and YEAR.

Data Type

Accepts numeric data for all arguments. Returns numeric data. For more information, see Data Type for Each Cell Type.

Example

DATE(A1,B1,C1)
DATE(2000,1,1)=36526
DATE(2001,2,10)=36932