Counting out 10 days from today and then adjusting to the following business day
I have a current formula that counts out 10 calendar days from an entered date. if the calculated date lands on a weekend or holiday, it currently displays the previous business day (usually a Friday). I would like it instead to display the following business day (usually a Monday).
I'm not sure which part of the formula to adjust to make that change. I've attached a snippet of the current formula. Any help would be greatly appreciated.
Thanks!
|