Forum Discussion

Copper Contributor

Jan 16, 2020

Putting a date list in DAY order

I have an *.xlsx client list that includes the clients' birthdates. I need to put it in order by the DAY of birth, regardless of the year. I can't find any function that allows me to do so. Is there ...

Formulas and Functions

mathetes

Gold Contributor

Jan 16, 2020

anadyer

Don't need to make it so complicated. Here's an example.

Full date in cell A1

MONTH(A1)

DAY(A1)

Then sort by month and day....

Example attached (Excel does wonderful things with Date and Time functions. Explore them, using this as your first case study)

Sort by day forget year.xlsx9 KB

anadyer

Copper Contributor

Jan 16, 2020

mathetes

Thanks so much! I figured I was trying to make it too complicated, hadn't thought about doing month and day separately then sorting on both. Definitely appreciate the prompt (and effective) response!