Skip to Content

DATEVALUE

Converts a date in the form of text to a serial number

Syntax

DATEVALUE(date_text)

Parameters

  • date_text: Required. Text that represents a date in an Excel date format

Example

=DATEVALUE("1/15/2024")
Returns: Date serial numberSince: Excel 2003