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!

Attached Images

Formula snip.PNG (15.8 KB, 19 views)

USE WEEKDAY() with ISO weekday numbers. Then you can use formula (on fly)

As you have XL2007 the WORKDAY function should be available?

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

=workday(e6+9,1)
?

WORKDAY() is a bit tricky function. It is logical to assume, that when you want to move the date only when it falls on weekend, and otherwise to let it unchanged, the 2nd parameter will be 0. Forget logic there - with 0 as parameter you get same date back - workday or not. Instead you have to use