DATEVALUE

The DATEVALUE function converts a date that is stored as Text into a Date.

Use

DATEVALUE( text )
Create a date from the text value.

Parameter	Required	Description
text	Yes	the text that represents a date in local format

Returns

Date

Use with literals

DATEVALUE("31/01/2024")

returns a Date representing 31 January 2024