Share via

Excel DATEVALUE function

Anonymous
2023-06-12T10:28:31+00:00

Try to use the Excel function DATEVALUE(cell) but got systematically #VALUE!" error message. The cell content example can be anything such as 1/1/2023 or 45000. However, when putting DATEVALUE("1/1/2023)", it works well

Microsoft 365 and Office | Excel | For business | 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

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-06-12T11:00:01+00:00

    You can =A1 directly for a date and set to number format.

    Image

    0 comments
  2. HansV 462.6K Reputation points MVP Volunteer Moderator
    2023-06-12T10:49:06+00:00

    From DATEVALUE function:

    "The DATEVALUE function converts a date that is stored as text to a serial number that Excel recognizes as a date."

    1/1/2023 and 45000 are not text values. "1/1/2023" is text.

    0 comments