sort by month and date only

[robnsd]

Is there a way to sort by month and day only? For example, the field
"Date" is in a format mm/dd/yyyy but I want to sort it only by mm/dd
so that January 1, 2004 comes before October 10, 2003. Does that make
sense?

Robert

1/1
1/2....
2/1
2/2...
3/1
3/2...
etc.

 

[Fred Smith]

The way to do this is to set up a helper column with just the month and the day.
One formula is:

=date(year(today()),month(a1),day(a1)

Then sort on that column.

Another option is to restructure your data to have separate columns for the
year, month and day.

 

[Guest]

I'd tweak that slightly, Fred

=DATE(0,MONTH(A1),DAY(A1))

otherwise 29th Feb will be equal to 1st March and might sort the wrong way
round....

or just use

=TEXT(A1,"mmdd")

 

[Dave Peterson]

One more:

=text(a1,"mmdd")

and sort by that column.

 

[robnsd]

One more:

=text(a1,"mmdd")

and sort by that column.






--

Dave Peterson- Hide quoted text -

- Show quoted text -

Thanks,

Works great.

Robert