DATEVALUE

Convert a date in text format to a valid date

Example

Sponsored Link

DATEVALUE

Purpose 

Convert a date in text format to a valid date

Return value 

A serial number that represents a particular date in Excel.

Syntax 

=DATEVALUE (date_text)

Arguments 

  • date_text - A valid date in text format.

Usage notes 

If date_text is a cell address, the value of the cell must be text. If date_text is entered directly into the formula it must be enclosed in quotes.

Will return a #VALUE error if date_text refers to a cell that does not contain a date formatted as text.

Sponsored Link

0 votes. 0 / 5