Google Spreadsheet Function - DATEVALUE

Function Name

DATEVALUE

Syntax

DATEVALUE(text)

Description

Returns the internal date number for text in quotes. Text is a valid date expression and must be entered with quotation marks.

Example:

Google DateValue Function Example

	A	B
1	Formula	=DateValue("31/01/2013")
2	Result	41,305