Blog of Calc LLC

DATEVALUE function converts date in a string to a number. Syntax DATEVALUE(date) Example Notes DATEVALUE function converts a date into an number such as 43880. You either need to format it as date, or use TO_DATE function to display it as a date.