Birthday & Anniversary Tracker | Google Sheets Template

Never forget a birthday or anniversary again. Add each person once and this Google Sheet counts down to every special day, shows the age they are turning, keeps your gift ideas and budget together and lays out the whole year on one page.

WHAT'S INSIDE (7 tabs)

- START HERE: quick setup steps and tips

- Dashboard: next special day, dates this month, gifts to buy in the next 30 days, budget this month, dates per month, dates by group, gift budget by month, gift status and a countdown list of what is coming up next

- Upcoming: pick the next 7, 30, 60, 90 or 365 days and see everything sorted by date with weekday, countdown, age turning, gift idea, budget and ticks

- People & Dates: name, group, occasion, month and day, optional year, gift idea, budget, gift bought and card sent ticks, with next date, weekday, days until, countdown, age turning (or years together) and a status

- Year Calendar: all 12 months on one page with every birthday and anniversary, sorted by day

- Gift Ideas & Log: date, who it is for, occasion, gift, where to buy, cost and status (idea, bought, wrapped, given)

- Setup: currency, your name, reminder days, monthly gift budget, groups, occasions and gift statuses

HOW IT WORKS

1. After purchase, download the PDF from the link in your confirmation email.

2. Click the link. Google asks you to make a copy, which is saved to your own Google Drive.

3. Add your people and their dates once. Countdowns, reminders and the calendar update every day by themselves.

GOOD TO KNOW

- Two versions included: one with sample data to explore and a blank one ready for your people

- Works all year round for birthdays, wedding anniversaries, work anniversaries and any other date you want to remember

- The year is optional: add it to see the age someone is turning or how many years you have been together

- Dates inside your reminder window are highlighted, so you know when to buy a gift or send a card

- Pick your currency from a list of 25 symbols or type your own

- Works in Google Sheets on computer, tablet and phone. A free Google account is needed. Not made for Excel or Numbers

- Cells that calculate show a gentle warning if you try to edit them, so formulas are not deleted by accident

- This is a digital product. No physical item will be shipped

- For personal use only. Please do not share or resell

- Because this is a digital download, returns are not accepted. If you have any problem, reply to your download email and I will be happy to help