In my Excel workbook, I have "November 10th". I want every cell in the column to the right to display a date 3 days later, but it has to be a weekday Monday - Friday, it can't fall on a Saturday or Sunday. So if "November 10th" is a Thursday the date on the cell next to it should state "November 14th".

CodePudding user response：

Having the date in A1, use =WORKDAY(A1,3).

You can also put the third argument to exclude holidays in this function.