Return to site

Next Birthdate Formula

Business Problem:

Often times businesses will want to track customers/clients birthdays. However, it's also nice to know that a birthday is coming up (in the future) instead of just the birthday date.

Formula Rule Solution:

MONTH( Birthdate ) >MONTH(TODAY()),
DAY(Birthdate) + 1 > DAY(TODAY())
DATE( YEAR(TODAY()), MONTH( Birthdate), DAY(Birthdate)),
DATE( YEAR(TODAY())+1, MONTH( Birthdate), DAY(Birthdate))

* This formula works with any date field but Birthdate is the standard field name on Contacts

** Please note: Person Account fields are not yet available via formula's so this PersonBirthdate will not work here.