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:
IF(
AND(
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.
