How do I list dates without years?
 

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

How do I list dates without years?
 

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 specialvalues in place

Note: will sort alphabetically by month


Gord Dibben MS Excel MVP

On Mon, 15 Mar 2010 16:53:02 -0700, Osborne
wrote:

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