Google Spreadsheet Function - DATE

Function Name

DATE

Syntax

DATE(year, month, day)

Description

Converts a date written as year, month, day to an internal serial number and displays it in the cell's formatting. Year is an integer between 1583 and 9956 or 0 and 99. Month is an integer between 1 and 12. Day is an integer between 1 and 31.

Example:

Google Date Function Example

	A	B
1	Date	11/01/2013 11:05:10
2	Formula	=Date(Year(B1),Month(B1),Day(B1))
3	Result	11/01/2013