if-statement: If today = date_in_cell (or iteration of today + X)

lundi 9 juillet 2018

I want to send email reminders every X days (after the date in cell) until user changes status in row.

Once-off date conditions are easy EG:

If date = today OR date = today + 2 OR date = today + 4

On my "settings" sheet I have a "frequency" setting where the number of days between email reminders are set.

Is it possible to put a loop within an if statement? EG:

If today = date_in_cell OR today = date_in_cell + any multiple of X

IE - Date in cell is Monday. I want an email on Wednesday, Friday, Sunday, Tuesday, Thursday, ETC (forever).

if-statement