DATEVALUE

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

Examples

Make a copy

DATEVALUE accepts different input string format.

Sample Usage

DATEVALUE("1969-7-20")

DATEVALUE("7/20/1969")

DATEVALUE(A2)

Syntax

DATEVALUE(date_string)

  • 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.

Notes

  • 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.

true
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.

Search
Clear search
Close search
Google apps
Main menu
3687840639388505421
true
Search Help Center
true
true
true
true
true
35
false
false