Never forget a birthday again.
Everyone’s birthday and anniversary in one list, sorted by what’s coming up next, with the days to go and the age they’re turning. No macros.
✓ One-off payment ✓ Instant download ✓ Excel for Windows & Mac
| Name | Occasion | Date | Days | Turning | Alert |
|---|---|---|---|---|---|
| Mom | Birthday | 29 Sep | Today | 68 | Today! |
| Jake | Birthday | 02 Oct | 3 days | 35 | This week |
| Sarah & Tom | Anniversary | 05 Oct | 6 days | 14 | This week |
| Priya (work) | Birthday | 11 Oct | 12 days | This month | |
| Olivia | Birthday | 28 Oct | 29 days | 33 | This month |
| Grandma | Birthday | 02 Nov | 34 days | 88 | Later |
It’s always the ones you meant to remember
Remembering on the day
Realising at 6pm it’s your friend’s birthday, with no time for a card.
“How old is Grandma now?”
Working out ages and anniversary years in your head, and getting it wrong.
Scattered everywhere
Some dates in your phone, some on a calendar, some only in your head.
Add each date once. The list does the rest.
Add your dates
Name, occasion and the original date, like 14 March 1956. Don’t know the year? That’s fine too.
See what’s next
The Upcoming tab lists everything in date order, with the days to go and the age or years.
Print the year
The Year at a Glance tab puts every date on one printable page.
Know exactly how old they’re turning
Type the original date once. The list works out the next date, the day of the week and the age they’re turning, or how many years for an anniversary. It rolls on to next year by itself.
- Next date and day of the week
- Age or anniversary years
- Works even if you don’t know the year
| Name | Date | Year known? | Next date | Turning / years |
|---|---|---|---|---|
| Dad | 14 Mar 1956 | Sun 14 Mar 27 | 71 | |
| Our wedding | 20 Jun 2015 | Sun 20 Jun 27 | 12 | |
| Sam (work) | 11 Apr | No | Sun 11 Apr 27 | |
| Grandma | 02 Nov 1938 | Mon 02 Nov 26 | 88 |
Every date on one page
The Year at a Glance tab lists every birthday and anniversary month by month, in date order. Print it and stick it on the fridge.
- 12 months on one printable page
- Today’s date highlighted
- Updates when you add a date
| 2 | Jake |
| 5 | Sarah & Tom |
| 11 | Priya |
| 28 | Olivia |
| 2 | Grandma |
| 2 | Ben |
| 19 | Uncle Bob |
See what’s coming, in order
The Upcoming tab shows the next 15 dates with Today!, This week or This month alerts, and counts what’s coming in the next 7 and 31 days.
- Colour-coded alerts
- Gift ideas and cards sent
- Dates by month chart
| Name | Occasion | Date | Days | Turning | Alert |
|---|---|---|---|---|---|
| Mom | Birthday | 29 Sep | Today | 68 | Today! |
| Jake | Birthday | 02 Oct | 3 days | 35 | This week |
| Sarah & Tom | Anniversary | 05 Oct | 6 days | 14 | This week |
| Priya (work) | Birthday | 11 Oct | 12 days | This month | |
| Olivia | Birthday | 28 Oct | 29 days | 33 | This month |
| Grandma | Birthday | 02 Nov | 34 days | 88 | Later |
For anyone with more than a few birthdays to remember
Families
Parents, grandparents, kids, cousins and in-laws, all in one list.
Friends
Birthdays and anniversaries of the people you’d hate to forget.
Teams & offices
Colleagues’ birthdays and work anniversaries, so no one gets missed.
Everything you get
- Room for 200 dates
- Birthdays, anniversaries, work anniversaries and your own occasions
- Next date, day of the week and days until
- Age they’re turning or years married
- Today!, This week and This month alerts
- Upcoming list, sorted by date
- Printable Year at a Glance calendar
- Groups, gift ideas and a card-sent tick box
- Works every year, with no updating
One-off payment. Yours to keep.
Get instant access $4.99Secure checkout by Payhip · Card or PayPal
Download link emailed straight away
Hi, I’m Lee
I run Sheet Leveller on YouTube, where I make quick, no-nonsense Excel tutorials.
This list is built on the DATEDIF and date formulas from my “age from date of birth” tutorial, one of my most-watched videos.
Questions
What if I don’t know someone’s birth year?
Type any year and pick No in Year known. The date works as normal and the age is left blank.
Does it work next year?
Yes. The next date rolls forward by itself every year.
What about 29 February birthdays?
In years that aren’t leap years they show on 1 March.
Can I add other occasions?
Yes. Add your own occasions and groups on the Settings tab.
Does it use macros?
No. It’s a normal .xlsx file, so there are no security warnings and nothing to enable.
Which versions of Excel does it work with?
Microsoft 365, Excel 2010 or later on Windows, and Excel for Mac. It’s built for Microsoft Excel.
Is this a subscription?
No. You pay once and the file is yours to keep.
Be the one who always remembers.
Every birthday and anniversary, with the days to go and the age they’re turning.
Get the list $4.99Not ready yet? Try the free Birthday Countdown List.