Forum Discussion
DATEVALUE Function returns #VALUE! Error
I'v tried setting cell format to Text, any thoughts?
What are you using ar argument for the DATEVALUE function?
And what is your system date format? M/D/Y as in the USA, D/M/Y as in many European countries, or Y/M/D as in the ISO date format?