Forum Discussion
DATEVALUE Function returns #VALUE! Error
I'v tried setting cell format to Text, any thoughts?
OK, yes, but I wish to create the serial number form of the date for sorting.
I am going to create a an identifier using several values by concact function. The date serial number will be the first value for sorting