Is there a formula that can ensure that if a "Due Date" falls on a weekend day, it automatically adjusts to the proceeding Friday?
I been using calendar days (DATEADD) instead of (WORKDAYS) in my DUE DATES formulas because I'm tracking an operational process that does not strictly adheres to standard business days.
However, I need to adjust weekend dates to the preceding Friday to align with operational realities where certain tasks can't be completed on weekends. I've tried various formulas to no avail. Thank in advance for any assistance!