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.
Solved
Looking for 55th birthdays in the current month
+5Best answer by Justin_Barrett
Adding a unit as a third argument to the IS_SAME() function will make that happen:
IS_SAME({55th Birthday}, TODAY(), "month")
+21Adding a unit as a third argument to the IS_SAME() function will make that happen:
IS_SAME({55th Birthday}, TODAY(), "month")
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.