Sorting by month, disregarding the year

G

Guest

I have a list of names in one column, and their date of birth in another
column.
I want to sort day and month, disregarding the year, in order to see who has
a birthday this month. But how ?
 
B

Bob Phillips

In a helper column, add a formula of

=MONTH(B2)

copy down, and sort by the helper column.
 
M

Myrna Larson

Or, if you want to sort by month and DAY, make the formula

=MONTH(B2)*100+DAY(B2)
 

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 a date by month, date and then year. 2
Min and Max Dates in Range that Contains Zeroes, Dates, and Number 5
Sorting date fields by month excluding year 1
Excel Vba to change displayed year automatically. 14
Sort by date but not year 4
How do I list dates without years? 1
Sort by date month and not year 4
Access Access 2007 Report Question 8

Top