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
|