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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting by month, disregarding the year 3
Calculating Difference Between Two Dates Using Only Year 5
Sort by date but not year 4
Averaging a list of dates / ages 1
Date Reformating Question 2
I need help with this program written in Visual Basic for Excel 2007. 4
Sorting a date by month, date and then year. 2
finding date difference 3

Back
Top