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:

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.