DATEVALUE function does not work intermittently

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.

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

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.

Regards,
Rory

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: