This template allows you to keep track of events like birthdays and anniversaries. You can also create more events in the ‘Settings’ sheet.  In the ‘Input’ sheet you walk through the steps of selecting the event type, adding the individual’s name and date, etc.  

I have included some conditional formatting as a reminder for sending a card or buying a gift.


Download my Excel file

Download the file here or  here from my OneDrive (file 00113)


Watch my YouTube video

I also created a video that shows you how to use the template.  


Subscribe to my YouTube channel and learn more!

See my free templates here!


  1. Laura Jackson says:

    Hi team
    Is there a way to create;
    1. Age Colour [which would highlight significant birthdays]
    2. Total Years Column [which would highlight significant work milestones]
    Any help would be super 🙂 🙂

  2. Laura Jackson says:

    Apologies, I was hasty in sending this.
    I would like to include an Age Column [not colour] and a Total Years Column in your Birthday Anniversary Tracker template.

    1. Kevin Lehrbass says:

      Hi Laura,
      I added a file called “00113b_Birthday and Anniversary Tracker_Jan 6 2015.xlsx” to my onedrive.” that has a column for ‘Age’.

  3. Deborah Flowers says:

    I would like the “description” column to be wider (I’d like to use that to enter the person’s address). Is there a way for me to widen that column?

    1. Kevin Lehrbass says:

      Hi Deborah,
      On the ribbon select ‘View’ and check ‘Headings’. Then you can select any of the columns and make it wider.
      Thanks for visiting my site Deborah.

  4. rosa maria says:

    thank you, I appreciate this. I only wish I would of found this sooner. works great, so easy to use.

    1. Kevin Lehrbass says:

      Hi Rosa,
      I’m glad that you’ve found it helpful.
      Thanks for visiting my blog.

Post a comment