Hi John,
I also remember using the DATEVALUE function in that way in pre-Excel 2021 versions; there is even an example given in this blog post, and it also does not work for me in the Excel 2021 or Microsoft 365 version.
On the other hand, text strings such as “dd-mm-yyyy” are still accepted by the function!
Br,