DATEVALUE function not working

[davidam]

Hello Everyone,
I just acquired a new computer and a newly purchased copy of Excel 2021. A spreadsheet that I have been working with for years has a new problem. The DATEVALUE function returns #VALUE for everything.
I downloaded and repaired my copy of office and the problem was not fixed. I imagine this is a mission critical feature for many users; it certainly is for me. Has anyone else noticed this? Maybe my new computer is glitchy, although I doubt it; when I put =Today() into a cell if returns the proper date. When I reference that cell with DATEVALUE, I get #VALUE.
Thanks,
David

 

[RoryA]

There you are - it's expecting yyyy-mm-dd not dd/mm/yyyy. What other options are there in the 'Short date:' dropdown list?

 

[davidam]

When i change the formula to: DATEVALUE(Y&"-"&"D&"-"&M) it works!
Would those regional settings what you would normally expect to see?

 

[davidam]

 

[RoryA]

Change it to the second option, and you should be able to use your original dd/mm/yyyy format.

 

[davidam]

TYSM !! This has been a frustrating few days!

 

[RoryA]

You're welcome.

 

[Scott Huish]

The DATE function would be shorter, then you could just feed it the values
Format is:
=DATE(year,month,day)