Birthday List Checker

Your birthday list sits in a spreadsheet, a notes app or a group chat, and nobody can tell whose birthday is next without a formula that breaks every January. This free birthday list checker does the rolling forward for you: paste the names and birthdates, and it works out each person’s next birthday, how many days away it is, and the age they will turn.

Write each line as a name, then a birthdate — for example “Amara, 8 Nov 2015”. Dates in DD/MM/YYYY, MM/DD/YYYY, YYYY-MM-DD or with a written month all work. Leave the year off if you only know the day and month.

Paste your list and press “Check birthdays”.

NameNext birthdayWeekdayDays untilAge turning

How the upcoming birthdays from list calculator works out next birthdays

A birthday is a date that repeats, so the maths starts by taking the day and month from each birthdate and placing them in this year. If that date has already passed, the tool moves it to next year instead. That one step is the part most spreadsheet formulas get wrong, because they either leave the birthday in the past or push every date a year forward by mistake.

Take someone born on 30 October. In early November their birthday this year is already gone, so the tool looks to 30 October next year and counts the days from today. Someone born on 8 November, on the other hand, keeps their birthday this year, just a few days away. The age works the same way: it is the year of that next birthday minus the birth year, so you see the age they will turn, not the age they are now.

Leap-day birthdays get a small adjustment of their own. A person born on 29 February has no birthday in an ordinary year, so the tool counts 28 February as their birthday in non-leap years and 29 February when February has 29 days. Their age still steps up by one each year, and the date shown in the table tells you exactly which day the tool used.

Checking birthdays in the next 30 days

Most of the time you do not need the whole year, just the birthdays that are close enough to plan for. The window selector does that job: pick 30, 60 or 90 days, or all birthdays if you want the full sorted list. With 30 days chosen, the table shows only the people whose next birthday falls inside that window, and the count above it tells you how many there are.

That count is the number to act on. If it says three birthdays in the next 30 days, those are the cards to buy, the cakes to order and the messages to send. The rest of the list is still there, just hidden until you widen the window. And if you want to plan ahead from a different date, the “Count from” box lets you set your own starting day, so you can check what is coming up from the first of next month or from the day a school term starts.

It is a different job from counting down to one date on its own. If you only have a single event in mind, the Bulk Days-Until / Days-Since List is the quicker check. This tool is for the whole list at once, when the question is not “how long until one birthday?” but “whose birthday is next, and who follows them?”

Who has a birthday next week, from the whole list

Paste the whole list and the checker sorts everyone by their next birthday, showing the days until it and the age they will turn. A 30-day window keeps the list short enough to act on.

Sorting a whole team or family list by upcoming birthday

Paste the list exactly as you keep it, one person per line, with a comma or a tab between the name and the date. A family list might read “Mum, 14 May 1962” next to “Zara, 3 June 2011”, and a class list might hold thirty pupils in the same shape. The tool reads each line, works out the next birthday for that person, and sorts the whole table by days until, nearest first, so the person at the top is always the next one to celebrate.

Dates can arrive in several shapes, and the tool accepts the common ones: 14/05/1990, 05/14/1990, 1990-05-14, and written months such as 14 May 1990 or May 14, 1990. If a line will not parse, it is not dropped quietly. It appears under the table in a short list of lines that could not be read, so you can fix a typo or a missing date and run the check again. Teachers planning a term will find the same habit useful alongside the School Term Lessons Planner, which keeps track of what is left to teach while this one keeps track of whose birthday is coming up.

How to use the birthday list checker

  1. Paste your list of names and birthdates into the box, one person per line.
  2. Choose how far ahead to look: 30, 60 or 90 days, or all birthdays.
  3. If you want to count from a different day, set it in the “Count from” box; otherwise the tool counts from today.
  4. Press “Check birthdays” and read the sorted table, with the next birthday, the weekday, the days until it and the age each person will turn.

Worked example: a 12-person list, sorted by next birthday

Here is the same check run on a family list of 12 names, counted from 5 November 2026 with the window set to 30 days. Press “Load example” in the tool above and you will see this exact list, with the same six birthdays inside the window.

Name Next birthday Weekday Days until Age turning
Amara 8 Nov 2026 Sunday 3 11
Ben 12 Nov 2026 Thursday 7 38
Chloe 19 Nov 2026 Thursday 14 25
Dan 25 Nov 2026 Wednesday 20 51
Ella 2 Dec 2026 Wednesday 27 16
Farah 5 Dec 2026 Saturday 30 32

Six birthdays fall inside the 30 days, so the count reads “6 birthdays in the next 30 days”, and the other six names sit outside it. Gus is the nearest miss at 34 days, on 9 December, and Hana follows on 21 December. Ivan’s birthday is 3 January 2027, Jess’s is 14 February 2027, and Lena’s is 30 October 2027, because her birthday this year has already passed.

Karim is the leap-day case in this list. He was born on 29 February 2004, and 2027 is not a leap year, so his next birthday is shown as 28 February 2027, when he turns 23. Farah shows why the edge of the window matters, too: her birthday is exactly 30 days away, on 5 December, and she is still counted, because the window includes birthdays on the thirtieth day itself.

Frequently asked questions

What happens to 29 February birthdays?

They are counted on 28 February in years when February has only 28 days, and on 29 February in leap years, and the age shown is the age the person turns on that date.

Can I paste dates in any format?

You can paste the common ones: DD/MM/YYYY, MM/DD/YYYY, YYYY-MM-DD, and dates with a written month such as 14 May 1990 or May 14, 1990, separated from the name by a comma or a tab, and any line the tool cannot read is listed under the table so you can fix it.

Does the list need birth years?

No, you can leave the year off and just write the day and month, such as “Amara, 8 Nov”, and the tool will still work out the next birthday, the weekday and the days until it, showing a dash instead of an age, so add the year only if you want to see the age each person will turn.

Can I check a whole team list for upcoming birthdays?

Yes. Paste the team or family list with birthdays and the checker sorts everyone by next birthday, showing the days until each one and the age they will turn. Birth years are optional.

Who has the next birthday on my list?

Paste the list and the checker puts the nearest birthday at the top, with the days until it and the age that person will turn. The list stays sorted by next birthday, so the next one is always first.

Paste your list, pick your window, and you will know in seconds whose birthday is next. No formula to fix in January, no scrolling through a spreadsheet, and no missed birthday that was hiding three rows down.

Leave a Comment