Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Find instances in table of a date that falls in the next month

173 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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 next month. So, in September, the October 55th birthdays are indicated; in October, the November 55th birthdays will be flagged; and so forth.

Then, I’d like to have a column which shows the first business day of that month so that, using Zapier, I can pass that date on to my CRM. So, in the view I’m going to create, I’d like to see, in October, everyone who turns 55 in November, and I’ll want a column with the first business day in November.

1 Reply 1

IF(MONTH(TODAY())=MONTH({55TH BIRTHDAY}), “55 THIS MONTH”, IF(MONTH(TODAY())+1=MONTH({55TH BIRTHDAY}), “55 NEXT MONTH”))
let me know if it errors and ill actually test it