Change Dates

[Glenn Rawski]

I have a list of employees birth dates. I simply want to
drop the year and sort by month and day to get a birthday
list. Everytime I try to edit out the year, when I hit
enter the cell includes the year.

First I need to know how to edit the date properly and
then I need a macro that will go line by line and change
the dates.

Please help.

Thanks,

Glenn

 

[Gilles Desjardins]

You don't need a macro. Select the column that carries the dates, format,
cells, number, date: choose the format without the year.

HTH

Gilles

 

[Fred Smith]

Formatting mm/dd will display without the year, but won't change the sort.
Excel will still sort by year first.

Two options:

1. Change the year to anything consistent (eg, all mm/dd/00).
2. Add a helper column with the formula =month(a1), then sort by that
column.

 

[Bill in Verona, WI]

If A1 has 09/27/03, put in B1 =month(A1) and in C1 put =day(A1), then sort
first by month and then by day.