Using AutoSort to look the same date for multiple years

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

Thanks,
Will


---
Message posted from http://www.ExcelForum.com/

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

"wjsubs " wrote:

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

Thanks,
Will

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson