DATEVALUE Function in Google Sheets

Converts a date in text format to a serial number date value.

DATEVALUE Function

The DATEVALUE function converts a date in text format to a serial number date value.

Syntax

DATEVALUE(date_string)
  • date_string: The date in text format (e.g., “2024-08-14” or “14-Aug-2024”).

Examples

  1. Basic Example

Convert the text “August 14, 2024” to a date value:

=DATEVALUE("August 14, 2024")
  1. With Different Formats

If the text date format is “14/08/2024”:

=DATEVALUE("14/08/2024")

Notes

  • This function is useful for converting dates stored as text into serial numbers that Google Sheets can recognize.
  • TEXT: Formats a number and converts it to text.