Converts a provided date string in a known format to a date value.


Make a copy

DATEVALUE accepts different input string format.

Sample Usage






  • date_string - The string representing the date.

    • Understood formats include any date format which is normally autoconverted when entered, without quotation marks, directly into a cell. Understood formats may depend on region and language settings.


  • The input to DATEVALUE must be a string - if a number or cell reference to a cell containing a number is provided, the #VALUE! error will be returned.

  • DATEVALUE returns integers that can be used in formulas. To get dates, change the cell format to Date

  • If providing an explicit string input to DATEVALUE rather than a cell reference, surrounding quotation marks are required.

  • Some date formats are not understood by Google Sheets. To quickly ensure that the desired date format is understood, type an example of it into an empty cell, without quotation marks.

See Also

TO_DATE: Converts a provided number to a date.

N: Returns the argument provided as a number.

DATE: Converts a year, month, and day into a date.

Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Clear search
Close search
Google apps
Main menu