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!

3 Comments

  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’.
      Cheers,
      Kevin

Post a comment