DATEVALUE

Description

Use this function to return the numeric date value for a date written in either year/month/day or month/day/year format. Supported in Chains.

DATEVALUE(YYYY/MM/DD)
or
DATEVALUE(MM/DD/YYYY)

This function has the following arguments:

Name	Required	Description	Valid input
`YYYY`	Yes	A four-digit year. (A two-digit year is presumed to be prefixed with "19".)	This must be an integer or a formula which results in an integer in the range 1900–9999.
`MM`	Yes	A two-digit month. (A single digit is acceptable.)	This must be an integer or a formula which results in an integer in the range 1–12.
`DD`	Yes	A two-digit day (A single digit is acceptable.)	This must be an integer or a formula which results in an integer in the range 1–31.

Use case	Formula	Explanation and Result
Determine the numeric (serial) value for a specific date.	`=DATEVALUE("2021/06/03")`	Result: The value of the supplied date: 44261 (3 June 2021)
Determine the numeric (serial) value for the date 45 days before the specified date.	`=DATEVALUE("1960/08/06")-45`	Result: The value of the date 45 days prior to the date supplied: 22134 (6/22/1960)
Determine the numeric (serial) value the date 28 days after a date referenced in a cell.	`=DATEVALUE(A3)+28`	Result: This formula returns the `#VALUE!` error, because cell references are not supported.
Extract the date form a cell that has additional content.	`=DATEVALUE(LEFT(B1,10))`	This formula uses LEFT to return the first 10 characters in B1 (the date characters), and then applies DATEVALUE to convert the result. Result: 45580 (10/15/2024)

Applying a "Date" format to the cell will display the date in MM/DD/YYYY format.