How do I list dates without years?

  • Thread starter Thread starter Osborne
  • Start date Start date
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
 
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
 
Back
Top