sorting dates

[David Urso]

How do I sort a column of dates by month (ie. I want all the records fo
those people who are born in April)

 

[Frank Kabel]

Hi
you may use a helper column (lets say your dates are in column A and
your helper column is C): Enter the following in C1:
=MONTH(a1)
and copy down.
Now use this helper column for sorting

 

[Richard O. Neville]

If you just sort the column "ascending" or "descending," you will get, say,
January 1950 to December 1975, which won't help you. Here's what I do: set
up a second column next to the birth dates. Format the column to indicate
the month only; mmm or mm will do this. If the dates start in cell C2, enter
in D2 the formula "=C2" and spread this formula down to all the dates. Each
entry in column D will show Jan, Feb, Mar, or 01, 02, 03, etc.

Then, insert the title "Mo" in D1, sort the whole list by the "Mo" column,
and you will isolate all the people born in each month, regardless of year.

 

[Bob Phillips]

You need a helper column.

In B1, add =MONTH(A1) and sort A & B on B.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Jason Morin]

You could apply an Advanced Filter:

1. Select an open cell (say J15).
2. Assuming dates in column B, enter this formula:
=MONTH(B2)=4
3. Click any cell in your data table.
4. Data > Filter > Advanced Filter
5. Select J14:J15 for the criteria range, ensuring J14 is
empty.

HTH
Jason
Atlanta, GA