Related Topics:

Spreadsheet Mathematical Functions

Function Wizard Functions

DATE

Description: Returns the serial number for a specified date, where the YEAR, MONTH and DAY are separated by commas. For example, =DATE(2011,4,15) returns 40648, which is the serial number that is equivalent to April 15, 2011.

Syntax: DATE(Year, Month, Day)

If Year is between 0 (zero) and 1899 (inclusive), the software adds that value to 1900 to calculate the year. For example, DATE(108,1,2) returns the serial number representing January 2, 2008 (1900 + 108).

If Year is between 1900 and 9999 (inclusive), the software uses that value as the year. For example, DATE(2011,1,2) the serial number representing January 2, 2011.

Year must be greater than 0 and less than 10000.

If Month is greater than 12, Month adds that number of months to the first month in the year specified. For example, DATE(2011,14,2) returns the serial number representing February 2, 2012.

If Month is less than 1, Month subtracts that number of months plus 1 from the first month in the year specified. For example, DATE(2011,-3,2) returns the serial number representing September 2, 2010.

If Day is greater than the number of days in the month specified, Day adds that number of days to the first day in the month. For example, DATE(2011,1,35) returns the serial number representing February 4, 2011.

If Day is less than 1, Day subtracts that number of days plus one from the first day in the month. For example, DATE(2011,1,-15) returns the serial number representing December 16, 2010.

Remarks:

Example:

 

© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.