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

Data Analysis

  • Conditional Formatting New Rule with Formulas in Excel
  • How to calculate correlation coefficient Correlation in Excel
  • How To Create Pareto Chart in Excel
  • How to count table rows in Excel
  • How To Sort One Column or Multiple Columns in Excel

References

  • Extract all partial matches in Excel
  • Merge tables with VLOOKUP in Excel
  • How to get last row in mixed data with blanks in Excel
  • How to get relative column numbers in a range in Excel
  • Count unique text values with criteria

Data Validations

  • Excel Data validation must begin with
  • Excel Data validation number multiple 100
  • Excel Data validation specific characters only
  • Excel Data validation require unique number
  • How To Create Drop-down List in Excel

Add business days to date in Excel

by

If you need to add or subtract business days (workdays) to a date so that you can calculate a date in the future or past that skips weekends (and holidays),  then this tutorials is for you.

The example below shows how to  Add business days to date in Excel. You can use the WORKDAY function. Holidays are optional.

Formula

=WORKDAY(start_date,days,holidays)

Explanation

In the example, the formula in D6 is:

=WORKDAY(B6,C6,B9:B11)

This adds 7 days to Tuesday, Dec 22 and returns Tuesday, January 5, 2016.

How this formula works

By default, the WORKDAY function will exclude weekends (Saturday and Sunday). In this case, we have also supplied a list of 3 holidays that all fall in the date range being calculated, which means both the weekends and holidays will be excluded. The following table shows which dates are excluded with and without holidays provided (shaded gray). The final dates returned by WORKDAY are highlighted in yellow

No holidays Holidays provided
Wed, 23-Dec-2015 Wed, 23-Dec-2015
Thu, 24-Dec-2015 Thu, 24-Dec-2015
Fri, 25-Dec-2015 Fri, 25-Dec-2015
Sat, 26-Dec-2015 Sat, 26-Dec-2015
Sun, 27-Dec-2015 Sun, 27-Dec-2015
Mon, 28-Dec-2015 Mon, 28-Dec-2015
Tue, 29-Dec-2015 Tue, 29-Dec-2015
Wed, 30-Dec-2015 Wed, 30-Dec-2015
Thu, 31-Dec-2015 Thu, 31-Dec-2015
Fri, 01-Jan-2016 Fri, 01-Jan-2016
Sat, 02-Jan-2016 Sat, 02-Jan-2016
Sun, 03-Jan-2016 Sun, 03-Jan-2016
Mon, 04-Jan-2016 Mon, 04-Jan-2016
Tue, 05-Jan-2016 Tue, 05-Jan-2016
Wed, 06-Jan-2016 Wed, 06-Jan-2016

Subtract workdays

To subtract business from a date (instead of adding workdays) just use a negative value for days. For example to get a date 3 workdays before a date in A1, you can use:

=WORKDAY(A1,-3)

 

Post navigation

Previous Post:

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

Next Post:

Excel Data validation require unique number

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 NOT Function
  • Check multiple cells are equal in Excel
  • SWITCH function example in Excel
  • SWITCH function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • How to calculate nth day of week in month in Excel
  • Calculate number of hours between two times in Excel
  • Convert decimal seconds to Excel time
  • Calculate total hours that fall between two times in Excel
  • Convert date to text in Excel

Grouping

  • Running count group by n size in Excel
  • Categorize text with keywords in Excel
  • How to randomly assign people to groups in Excel
  • Group times into 3 hour buckets in Excel
  • Calculate conditional mode with criteria in Excel

General

  • How to create dynamic worksheet reference in Excel
  • AutoRecover file that was never saved in Excel
  • Common Errors in Excel
  • Basic text sort formula in Excel
  • How to calculate percent sold in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning