Help

Looking for 55th birthdays in the current month

Topic Labels: Formulas
Solved
Jump to Solution
380 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Graig_Stettner
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

1 Solution

Accepted Solutions
Justin_Barrett
18 - Pluto
18 - Pluto

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

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

See Solution in Thread

1 Reply 1
Justin_Barrett
18 - Pluto
18 - Pluto

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

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