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

Data Analysis

  • How To Sort One Column or Multiple Columns in Excel
  • Conflicting Multiple Conditional Formatting Rules in Excel
  • How To Filter Data in Excel
  • Subtotal function in Excel
  • Randomize/ Shuffle List in Excel

References

  • Get nth match with INDEX / MATCH in Excel
  • How to get first column number in range in Excel
  • How to create dynamic named range with OFFSET in Excel
  • Count unique text values with criteria
  • How to use Excel LOOKUP Function

Data Validations

  • Excel Data validation must begin with
  • Excel Data validation don’t exceed total
  • Prevent invalid data entering in specific cells
  • How To Create Drop-down List in Excel
  • 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 XOR Function
  • IFS function: Description, Usage, Syntax, Examples and Explanation
  • How to return blank in place of #DIV/0! error in Excel
  • SWITCH function example in Excel
  • OR function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • Get days, hours, and minutes between dates in Excel
  • Get age from birthday in Excel
  • Convert time to time zone in Excel
  • Convert date string to date time in Excel
  • Get work hours between dates and times in Excel

Grouping

  • Calculate conditional mode with criteria in Excel
  • If cell contains one of many things in Excel
  • How to randomly assign data to groups in Excel
  • Categorize text with keywords in Excel
  • Group times into 3 hour buckets in Excel

General

  • How to generate random date between two dates in Excel
  • How to Create Calendar in Excel
  • Automatically fill series of cells in Excel using AutoFill
  • Customize Ribbon In Excel
  • Spell Check in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning