Learn how to build a powerful Birthday 🎂 Tracking and Reminder System in Excel using just formulas and conditional formatting.
In this step-by-step tutorial, you’ll create a clean, easy-to-use list of names, birthdates and an “age next birthday” column. Then you’ll learn how to use formulas and conditional formatting to dynamically highlight upcoming birthdays within the next 4 weeks.
Whether you want to stay organized for friends, family, or colleagues, this automated tracker will make sure you never miss an important birthday again.
Formulas used in the video
=INT((TODAY()-B2)/365.25)+1
=AND($B2 <> "", MOD(DATE(YEAR(TODAY()), MONTH($B2), DAY($B2)) - TODAY(), 365) <= 28)
Download a copy of the file(s) used in this video: https://share.zight.com/OAu1yomD