DATEVALUE

Converts a date written as text, such as "29/4/24", into a real date value. How the text is read depends on the day-first or month-first locale.

When to use

Used when a "date" is really text and cannot be subtracted or grouped: wrap it in DATEVALUE or enter it as a real date. The class example =DATEVALUE("29/4/24") gives 45411.

See Lec 04.

Appears in

No references yet.