How do I list dates without years?

O

Osborne

I'm creating a list of birthdays that cannot contain the birth year. Since
there will be additions and deletions over time, I'd like to just have the
month and day in the column.
Thanks
 
G

Gord Dibben

Simply format column A as Custom mmmm dd

OR.................

Enter the birthdays in column A in regular m/d/y format.

In an adjacent column enter =TEXT(A1,"mmmm dd")

Copy and paste special>values in place

Note: will sort alphabetically by month


Gord Dibben MS Excel MVP
 
Top