Formula to Flag or Not Flag
Goal: Flag when the due date is in the next 7 days
No flag when the due date is BLANK or more than 7 days in the future
Two formulas that seem to work separately: =IF(Due Date2 <= (TODAY() + 7), 1, 0)
=IF(ISBLANK(Due Date2), 0)
Anyone know how I can combine these formulas to make both work?
Help Article Resources
Check out the Formula Handbook template!