Related Topics:

Spreadsheet Mathematical Functions

Function Wizard Functions

DATEVALUE

Description: Converts the specified date to a serial number. For example, the function returns 40777 if you enter "8/22/2011" or "22-AUG-2011."

Syntax: DATEVALUE(Date_text)

Remarks:

Example:

DATEVALUE("5-JUL") = 40729 [the serial number of the text date]

 

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