DATEVALUE

Converts a date string into a date value.

Sample Usage

DATEVALUE("7/9/2019")
DATEVALUE(C5)

Syntax

DATEVALUE(date_string)

• date_string - The string containing the date value.
  
  

Examples

DATEVALUE("7/9/2019") returns the date value 43655. 

Notes

• The string of text used in date_string should be within single or double quotation marks.
• Use the date data type to format the function's output into a date.
• The date_string text can be formatted in any of the same ways that the date data type can display data.