Overview

A simple, smart phonebook built in Notion to track birthdays and calculate the current age of my contacts. It combines contact info, birthday tracking, and automatic age calculation.

Highlights

  • Automatically calculates current age based on birth date
  • Sorts and highlights upcoming birthdays
  • Clean, searchable layout for regular use

Formulas used

  • Current age: dateBetween(now(), prop(“Birthdate”), “years”)
  • Next birthday: if(formatDate(dateAdd(prop(“Birthdate”), prop(“Current age”), “years”), “L”) == formatDate(now(), “L”), dateAdd(prop(“Birthdate”), prop(“Current age”), “years”), dateAdd(prop(“Birthdate”), prop(“Current age”) + 1, “years”))
  • When: if(formatDate(prop(“Next birthday”), “L”) == formatDate(now(), “L”), “🎂 Today”, if(formatDate(prop(“Next birthday”), “L”) == formatDate(dateAdd(now(), 1, “days”), “L”), “🎁 Tomorrow”, “in ” + format(dateBetween(prop(“Next birthday”), now(), “days”)) + ” days”))
Laura Stefan