DATEVALUE

Definition: DATEVALUE is a function that returns the serial number of a date based on a text string.

Syntax: =DATEVALUE(date_text)

Situation: This formula is suitable when you need to convert a text string to a serial number for use in date calculations.

Example: If you have a text string “January 1, 2021”, the serial number can be found using the formula =DATEVALUE(“January 1, 2021”), which returns 44197.