Looking for 55th birthdays in the current month

I have a list of people and their dates of birth. I’d like to know if that birthday falls in the current month. Right now, I have a column, the formula of which is IS_SAME({55th Birthday},TODAY()), which indicates if that birthday is today, but I’d like to see everyone in the list who turns 55 in the present month. So, in September, the September 55th birthdays are indicated; in October, the October 55th birthdays will be flagged; and so forth.

Adding a unit as a third argument to the IS_SAME() function will make that happen:

IS_SAME({55th Birthday}, TODAY(), "month")
1 Like

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.