Hi,
I'm trying to figure out the best way to get the result of a formula to automatically calculate to the following business day if the result is non-workday (weekend or holiday).
In cell C2, I have the date. In cell C4 I have C2+12 (that date + 12 calendar days). That results in a weekend date. I would like for excel to auto adjust that result to the next working day, 1/16/23.
I want to have this formula copied in all cells in red (12 calendar days). I've tried using the =WORKDAY option but E4 or E5 would be 1 day off (it would add one extra day even though those dates would be on a workday already).
Hopefully this makes sense. Any assistance is greatly appreciated.
I'm trying to figure out the best way to get the result of a formula to automatically calculate to the following business day if the result is non-workday (weekend or holiday).
In cell C2, I have the date. In cell C4 I have C2+12 (that date + 12 calendar days). That results in a weekend date. I would like for excel to auto adjust that result to the next working day, 1/16/23.
I want to have this formula copied in all cells in red (12 calendar days). I've tried using the =WORKDAY option but E4 or E5 would be 1 day off (it would add one extra day even though those dates would be on a workday already).
Hopefully this makes sense. Any assistance is greatly appreciated.
