Free Birthday and Anniversary Tracker: Perpetual Birthday Calendar, Birthday List with Ages and Gift Ideas, and Employee and Client Birthday and Work Anniversary Tracker (PDF, Word, Excel)

What is on the page

Perpetual calendar

Twelve months on one page with no weekdays or years, so the same sheet works every year.

Year born or married

On the list, the year of birth or the wedding year. Excel subtracts it from the current year to show the age they are turning or the anniversary number.

Gift idea, budget and spent

Ideas as you think of them during the year, and the budget for each, so gifts do not all land on one month's card statement.

Start date and years

On the workplace sheet, the start date and the years of service Excel works out, which drive milestone awards.

How we mark it and owner

The card, cake, gift or post for each person and who is responsible, so nobody is forgotten when the usual organizer is away.

Never miss a birthday again

Fill in the perpetual calendar once, from your phone contacts, social media and family, and pin it somewhere you see every day: inside a kitchen cupboard, on the fridge, or in the family command center. At the start of each month, look at the month ahead and buy or write the cards then. A card mailed in the US takes a few days, so posting a week ahead is safe. Include anniversaries, the dates of loved ones who have passed (people appreciate being remembered on those days too) and pets if your family likes that kind of thing.

Ages, milestones and gift planning

Writing the year of birth or marriage lets Excel work out the age or the anniversary number which matters for milestones: a 40th, a 50th, a 25th wedding anniversary deserve more planning than an ordinary year. Traditional anniversary gifts give a theme if you need one (paper for the first, wood for the fifth, tin for the tenth, crystal for the fifteenth, silver for the twenty-fifth, gold for the fiftieth). Write gift ideas on the list as soon as someone mentions something they would like; by the birthday you'll have forgotten. Add a budget for each person and the total for the year shows what gifts really cost, which helps with the household budget.

Birthdays and work anniversaries at work

Small acts of recognition matter at work, and they are easy to forget without a list. Agree a simple, fair policy (everyone gets the same card and cake, milestone work anniversaries get a gift) so nobody is left out because their manager forgot. Ask people whether they want their birthday marked at all; some prefer not, and you should record only the month and day, never the year of birth, to avoid age-related concerns. Start dates come from HR records, and the years of service are worked out for you. Client anniversaries are a good excuse for a thank-you note and help keep the relationship warm. Store the list where only the people organizing it can see it.

Editing the files

The PDFs are fillable. The Excel list works out ages, anniversary years and years of service from the year you enter, and totals the gift budget; sort it by date to see the order of the year. Print the perpetual calendar on card stock if it will live on the fridge.

Questions

What is a perpetual birthday calendar?

A calendar with only months and days, no weekdays or year, so it can be used every year. You write each birthday once.

How do I work out how old someone is turning?

Subtract their birth year from the current year. The Excel list does this for every row when you enter the year.

What are the traditional anniversary gifts?

Common ones are paper (1st), cotton (2nd), leather (3rd), wood (5th), tin or aluminum (10th), crystal (15th), china (20th), silver (25th), pearl (30th), ruby (40th) and gold (50th).

Should employers track employee birthdays?

Many do, with consent. Record only the month and day, not the year, and keep the list private to the organizers.

Can I use it as a gift budget?

Yes. The list has budget and spent columns with totals for the year.