What is the syntax to convert an input to date?

cDate(<date>)

‘examples
Dim example1, example2 As Variant
example1 = CDate("January 1 2040") '01/01/2040
example2 = CDate("1 Jan 2040") '01/01/2040