Forum Discussion
DATEVALUE Function returns #VALUE! Error
I'v tried setting cell format to Text, any thoughts?
I an using a cell as the argument. The Cell is date formatted MM/DD/YY
If the cell used as argument already contains a "real" date, there is no point in using DATEVALUE.
DATEVALUE expects a text string that looks like a date as argument.
If A1 contains the date 10/09/22, =DATEVALUE(A1) will return #VALUE!
If A1 contains a text value that looks like 10/09/22, =DATEVALUE(A1) will return the date 10/09/22.
- OK, yes, but I wish to create the serial number form of the date for sorting.
Excel stores dates as numbers, so you can sort them directly, without converting them to numbers.
For example:
10/09/2022 is stored as 44843
10/10/2022 is stored as 44844
10/11/2022 is stored as 44845
etc.
You can check this by setting the number format of a range with dates temporarily to General.
(Don't forget to restore the date format afterwards)
