DATEVALUE function

Description

String to serial date number function.

The function DATEVALUE(txt) returns the serial date number for the date expressed in the string txt.

Example

DATEVALUE("12.10.88") equals 68645 if the date format is MM.DD.YY.

Calculator

Related functions

• DATE function
• List of Date functions