Share via

DATEVALUE function does not work intermittently

Anonymous
2024-08-22T14:12:47+00:00

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.

Microsoft 365 and Office | Excel | Other | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

2 answers

Sort by: Most helpful
  1. Rory Archibald 18,965 Reputation points Volunteer Moderator
    2024-08-22T14:33:36+00:00

    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.

    Was this answer helpful?

    0 comments No comments
  2. HansV 462.6K Reputation points
    2024-08-22T14:14:52+00:00

    Do you notice a difference between input values for which the function works and input values for which it doesn't?

    Was this answer helpful?

    0 comments No comments