Link to home
Start Free TrialLog in
Avatar of SMadhavi
SMadhaviFlag for Canada

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
ASKER CERTIFIED SOLUTION
Avatar of barry houdini
barry houdini
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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