Forum Discussion
DATEVALUE Function returns #VALUE! Error
I'v tried setting cell format to Text, any thoughts?
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)
OK Thank You..