I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month.
I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then reminder will not be sent.
More context . . .
I have an inspection form that is required each month.
On the first Thursday of the month I want to send a reminder out to everyone who HAS NOT submitted their inspection yet.
On the second Thursday of the month I want to send a reminder out to everyone who STILL has not submitted their inspection.
and so on . . .
I would like to trigger the automation based on a date column, so I need that date column to ALWAYS be the next Thursday.
For Example;
Today is 09/03/25
Reminders need to be sent out on 09/04/25
Next week, however, reminders need to be sent out on 09/11/25
Then the following week reminders need to be sent out on 09/18/25
and then the week after 09/25/25, etc.
I have a formulas that return the current YEAR and the CURRENT month based on TODAY function.
I have been able to write a formula to return the first Thursday of the month, but having trouble trying to get that formula to be dynamic.