Syntax

DATEVALUE(Text)

Text (required) – This is the date stored as text you would like to convert to a serial number.

Example

In this example we convert a few different text dates to the serial number.

DATEVALUE function - 6