sorting Dates by Month

  • Thread starter Thread starter cousin_jammie
  • Start date Start date
C

cousin_jammie

Hi all. I have a database of clients with a column for birthday. The
dates are entered as 01/12/2000 (example) and are formatted to read
01-Dec-00. Id like to be able to sort the dates by month only, but
when I do a sort it sorts by the whole date, eg the year first, month
then day. Ive tried using the sort options Jan,Feb,Mar, etc, but that
doesnt seem to work. Id be grateful for any help anyone can give.

Thanks
Jan
:D
 
Jan,

Create a helper column with the formula

=MONTH(A1)

assuming the dates are in A, and sort by that column.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
You could use data>filter>autofilter>custom>greater than>=4/30 and less than
=5/30
 
Hi Bob and Don. Thankyou both very much for answering my query. Bob,
your suggestion was exactly what I was looking for and works a treat :)
... and Don, your suggestion helped in as much as I wasnt really aware
of that option, but now can use it elsewhere. Thanks again to you
both.

Regards
Jan
 
Jan,

Glad we helped.

Don often has a different perspective on things, makes life more interesting
<G>

Bob
 
Back
Top