Sorry for what is probably a very stupid question, but excel is driving me crazy.
I've imported a data set that is published by state, and I want to use a SUMIF function to aggregate the data by date. However, no matter how many permutations I've tried, I can't find a date format that excel will accept.
So far, I've gotten the date into the format mm/dd/yyyy. I've also cut and paste the dates as values only (in case any formulas were getting in the way), and changed the cell formats to "Date".
Unfortunately, the dates are still only recognized as general text.
What else do I have to do?
Note: The DATEVALUE function returns a #VALUE! error.
Bookmarks