From the course: Excel Power User Challenge

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Sort dates by day and month to find the birthday with the most people

Sort dates by day and month to find the birthday with the most people - Microsoft Excel Tutorial

From the course: Excel Power User Challenge

Start my 1-month free trial Buy for my team

Sort dates by day and month to find the birthday with the most people

“

- Right, check this out. We've got all of this data. We've got birthdays. And we would like this data sorted by the birth day. The month and the day, ignoring the year. See we're in charge of the birthday cakes and we'd like to know say, Misty Abbott was born February 2nd of 1990. How many other people might be celebrating their birthday on the 2nd of February, regardless of the year? Cause if there's just Misty, then we get a small cake. If there's 10 people then we're going to need a gigantic cake. So that's what we got to figure out. So find a way to sort this data by the birth day, ignoring the year. Then use a pivot table to figure out which birth dates have the most people. Again, just going by the day and a year, Paul's video worked it out and then come on back. Right, let's do it. I'm going to first put this into a table. Go home, format as table, grab that purple, okay. Then you know it, get rid…

Contents