How do I sort birthdays?

M

Marcelo

Hi,

you can use an auxiliar column with this formula =year(a2), copy it down,
sort by this column.

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Lois" escreveu:
 
D

Dave Peterson

You should be able to just sort by the date -- if those values are really dates.

On the other hand, if you wanted to sort by month (all January together no
matter the year), I'd use a helper column with:

=text(a2,"mmddyyyy")
drag down

And sort by this helper column.
 
L

Liz

Create other columns - one for the year and one for the month. Sort by
those columns. Ex:

A B C
1/1/2006 2006 1 (January)

The formula in column B would be "=YEAR(A1)" and the formula in column C
would be "=MONTH(A1)"
 

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

Working on birthday "book" for my wife and having layout/editing trouble 0
Sorting a Two Dimensional Table 2
Birthdays recreation in Outlook x64 3
Calculate horses age as at 1 August 6
Sort by date but not year 4
how do I sort dates by months? 2
How do I list dates without years? 1
sort a group 2

Top