DATEVALUE

  • Updated

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.