Using AutoSort to look the same date for multiple years

[wjsubs]

I have a columnar database that includes mulitple years of data. I wa
wondering if anyone knows how to use a custom autosort in order to vie
the same date for more that one year. I have chart that runs off o
the sorted data.

Thanks,
Wil

 

[Dave Peterson]

Instead of using a custom autosort, maybe you could use a helper column:

Say A2:Axxx contained your dates.
then
=text(a2,"mm-dd")

would show the month/day.

If it was ok to always use the same year:

=date(2000,month(a2),day(a2))

and format it as mm-dd (but don't display the year)

(2000 was a very good year. It allows you to use Feb 29.)