• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 267
  • Last Modified:

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
0
SMadhavi
Asked:
SMadhavi
  • 2
  • 2
2 Solutions
 
barry houdiniCommented:
Hello YRKS

I think you can do it that way - you just have a formatting issue. In the cell with the formula

=MONTH(A2)

just format that cell as general, then you'll see the month, i.e. 1....you currently have it formatted as a date...

regards, barry
0
 
jsdrayCommented:
just need to reformat the new column with general... not date
0
 
jsdrayCommented:
sorry..barry...didn't see you there
0
 
barry houdiniCommented:
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
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now