In the example shown, the formula in C7 is: This formula adds 7 days to the date in B7, excluding Tuesdays and Thursdays. To exclude specific days of the week you can either use a pre-configured code (see this page for a full list of presets) or provide your own “pattern code”. The pattern code must be 7 digits long and have either a zero for each day of the week, starting on Monday and ending on Sunday. Values equal to 1 are excluded, and days with zero values are treated normally. So, assuming you want to add 7 days to a date in cell A1, you can write formulas like this:

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.