Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • Conflicting Multiple Conditional Formatting Rules in Excel
  • How To Perform and Interpret Regression Analysis in Excel
  • How to Use Solver Tool in Excel
  • How to conditionally sum numeric data in an Excel table using SUMIFS
  • How to sum a total in multiple Excel tables

References

  • How to use Excel VLOOKUP Function
  • How to get first column number in range in Excel
  • Extract data with helper column in Excel
  • INDEX function: Description, Usage, Syntax, Examples and Explanation
  • Two-way lookup with VLOOKUP in Excel

Data Validations

  • Excel Data validation must begin with
  • Excel Data validation allow weekday only
  • Excel Data validation exists in list
  • Excel Data validation no punctuation
  • Excel Data validation unique values only

Add days exclude certain days of week in Excel

by

It you need to add days and exclude certain days of week in Excel then this tutorials is for you.

To add days to a date while excluding specific days (i.e. exclude Tuesdays and Thursdays, Wednesdays only, etc.) you can use the WORKDAY.INTL function with a special pattern code see the example below:

Formula

=WORKDAY.INTL(date,days,"pattern")

Explanation

In the example shown, the formula in C7 is:

=WORKDAY.INTL(B7,7,"0101000")

This formula adds 7 days to the date in B7, excluding Tuesdays and Thursdays.

How this formula works

The WORKDAY.INTL function is based on the WORKDAY function, which is designed to add work days to a date. WORKDAY automatically excludes Saturday and Sunday, and optionally can exclude a list of custom holidays. The WORKDAY.INTL does the same thing, but makes it possible to exclude any days of the week, in addition to holidays.

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:

=WORKDAY.INTL(A1,7,"0000011") // exclude Sat, Sun
=WORKDAY.INTL(A1,7,"0010011") // exclude Sat, Sun, Wed
=WORKDAY.INTL(A1,7,"0101011") // exclude Sat, Sun, Tue, Thu

Post navigation

Previous Post:

DECIMAL function: Description, Usage, Syntax, Examples and Explanation

Next Post:

AVERAGE function: Description, Usage, Syntax, Examples and Explanation

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • How to use Excel AND Function
  • Not Equal To ‘<>‘ operator in Excel
  • Nested IF function example in Excel
  • How to use Excel FALSE Function
  • IFS function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • Get project midpoint in Excel
  • How to show last updated date stamp in Excel
  • Series of dates by day
  • Calculate years between dates in Excel
  • Get month name from date in Excel

Grouping

  • Group arbitrary text values in Excel
  • Running count group by n size in Excel
  • Group numbers at uneven intervals in Excel
  • How to randomly assign data to groups in Excel
  • Categorize text with keywords in Excel

General

  • 3D SUMIF for multiple worksheets in Excel
  • How to calculate total from percentage in Excel
  • Count cells less than in Excel
  • How to calculate percent change in Excel
  • Cell References: Relative, Absolute and Mixed Referencing Examples
© 2026 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning