🎂 How to Use DateDif Function in Google Sheets | Calculate Age & Birthday Reminder Template
Want to calculate age or track birthdays in Google Sheets? 🎉 In this tutorial, I’ll show you how to use the DateDif function, along with DATE and TODAY(), to build a dynamic birthday reminder template.
By the end of the video, you’ll know how to:
✅ Calculate age from today’s date using DateDif
✅ Find the next birthday with the DATE function
✅ Highlight birthdays with conditional formatting (yellow = upcoming, green = today, red = past week)
✅ Build a calendar-style spreadsheet that automatically updates using TODAY()
This logic also applies to Excel, so you can use the same setup across platforms!
📖 References:
DateDif (Google Sheets) → https://snip.ly/vxnpgh
Date Function → https://snip.ly/6s6tk1
Times:
0:00 - Intro
0:30 - Template Setup
2:08 - Calculate Age (DateDif)
2:52 - Calculate Next Birthday (DATE Function)
4:00 - Adjusting Next Birthday (Advanced)
5:28 - Calculate Birthday Month
7:13 - Current Month (Who's Birthday is this Month?)
9:27 - Visual Appeal
📢 More Verdexes
Merch → https://teespring.com/stores/store-of...
Instagram → / verdexes
#googlesheets #datedif #excel #exceltips #birthdayreminder #spreadsheets #excelfunctions #excelpractice #verdexes