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.
Page 1 / 1
Adding a unit as a third argument to the IS_SAME()
function will make that happen:
IS_SAME({55th Birthday}, TODAY(), "month")
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.