SMadhavi
asked on
excel 2007 sort date by month
Hi There I have huge amount of data for the last 5 months
I have sorted data on submit date desc . Now I have to select data for the last 4 months from here.
IThe date format is mm/dd/yyy hh:mm:SS AM?PM
Now I tried creating a new coulmn called monthsort and used the formula Month(A2) expecting to see the month number there.
I donot see that instead I see a date of 01/01/1900
How would you do this.
Any help is appreciated.
YRKS
I have sorted data on submit date desc . Now I have to select data for the last 4 months from here.
IThe date format is mm/dd/yyy hh:mm:SS AM?PM
Now I tried creating a new coulmn called monthsort and used the formula Month(A2) expecting to see the month number there.
I donot see that instead I see a date of 01/01/1900
How would you do this.
Any help is appreciated.
YRKS
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
sorry..barry...didn't see you there
No problem jsdray....
Thinking about it a bit more, YRKS, I'm not even sure you need an extra column (and using the month might not work too well when you want the last 4 months in February because you'll need 1,2, 1, and 12)
Can't you just sort by the description you want and then by the date/time field (descending)? Dates will sort like numbers (assuming they are real dates -not text).
regards, barry
Thinking about it a bit more, YRKS, I'm not even sure you need an extra column (and using the month might not work too well when you want the last 4 months in February because you'll need 1,2, 1, and 12)
Can't you just sort by the description you want and then by the date/time field (descending)? Dates will sort like numbers (assuming they are real dates -not text).
regards, barry