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.

All Posts

Almost done…

We just sent you an email. Please click the link in the email to confirm your subscription!