More Formula Practice – Anniversary Dates

Like birthdays! If you have someone’s literal birth date you may find it hard to actually create a report of ‘This Week’s Birthdays’. Use a Formula column to solve that, using something like the following code:

add_year("Date of Birth",age_years( "Date of Birth",Today())+1)

In order to figure out how to use each of these formulas, use the help icons next to their names in the formula builder.