sorting Dates by Month

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
 
B

Bob Phillips

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)
 
D

Don Guillett

You could use data>filter>autofilter>custom>greater than>=4/30 and less than
=5/30
 
C

cousin_jammie

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
 
B

Bob Phillips

Jan,

Glad we helped.

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

Bob
 
D

Don Guillett

Did you say defective?

Bob Phillips said:
Jan,

Glad we helped.

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

Bob
Click to expand...
 
Top