I'm trying to figure out a formula for (K2) that would insert a date if 2 conditions were met.
1st condition cell (P2) is blank
2nd condition Today's date is at least 30 days beyond the date in cell (F2)
The resulting date needs to be either cell (F2) plus 30 days or the date of the current weeks Monday if that Monday's date is more recent than cell (F2) plus 30.
I've figured out some fairly out there formulas, but this one is a bit beyond my expertise.
Thanks for the help.
Bookmarks