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

Data Analysis

  • Chart Axes in Excel
  • Data Series in Excel
  • How to Create Area Chart in Excel
  • Error Bars in Excel
  • How to conditionally sum numeric data in an Excel table using SUMIFS

References

  • How to use Excel COLUMN Function
  • Get nth match with INDEX / MATCH in Excel
  • How to use Excel TRANSPOSE Function
  • How to get first column number in range in Excel
  • How to retrieve first match between two ranges in Excel

Data Validations

  • Excel Data validation don’t exceed total
  • Excel Data validation no punctuation
  • Excel Data validation whole percentage only
  • Excel Data validation unique values only
  • Data validation must not exist in list

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

  • IF function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel FALSE Function
  • Excel If, Nested If, And/Or Criteria Examples
  • OR function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel TRUE Function

Date Time

  • Get date from day number in Excel
  • Count birthdays by month in Excel
  • Calculate expiration date in Excel
  • Extract date from a date and time in Excel
  • How to calculate Day of the Year in Excel

Grouping

  • How to randomly assign people to groups in Excel
  • Map text to numbers in Excel
  • Group arbitrary text values in Excel
  • Group numbers at uneven intervals in Excel
  • Group times into 3 hour buckets in Excel

General

  • List worksheet index numbers in Excel
  • Zoom Worksheet in Excel
  • How to get Excel workbook path only
  • Count cells that contain errors in Excel
  • Find, Trace and Correct Errors in Excel Formulas using ‘Formula Auditing’
© 2026 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning