I have an older spreadsheet that uses the DATEVALUE function...properly! Sometimes it works and sometimes it doesn't. Anyone else have this problem? I have a 3 year old alienware aurora r11 with an i9 cpu etc.
January 10, 2025
Excel Top Contributors:
DATEVALUE function does not work intermittently
Report abuse
Thank you.
Reported content has been submitted
Do you notice a difference between input values for which the function works and input values for which it doesn't?
Best wishes, HansV
https://www.eileenslounge.com
Report abuse
Thank you.
Reported content has been submitted
Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
The input has to be text, and it has to be in a format that is recognised as a date based on your computer's regional settings.
Rory
Report abuse
Thank you.
Reported content has been submitted
Was this reply helpful?
Sorry this didn't help.
Great! Thanks for your feedback.
How satisfied are you with this reply?
Thanks for your feedback, it helps us improve the site.
How satisfied are you with this reply?
Thanks for your feedback.
Question Info
Last updated November 20, 2024 Views 51 Applies to: