Excel formula count business days between two dates

Calculate Number of Days Between Two Dates « The Excel Addict Blog

For example, if you have the date January 4, a Monday in cell B4, and January 11, also a Monday in cell C4, this formula will return For example, if you have holiday dates in H1: If you need take into account custom weekends i. If you need a date n workdays in the past or future, see the WORKDAY function. INTL function calculates the number of working days between two dates.

Learn Excel formulas and functions with clear, concise videos. Each video comes with a practice worksheet and audio transcript.

View the discussion thread. Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa.

NETWORKDAYS function - Office Support

Our goal is to help you work faster in Excel. Skip to main content. Training Videos Functions Formulas Shortcuts Blog.

Get workdays between dates. For example, if you have the date January 4, a Monday in cell B4, and January 11, also a Monday in cell C4, this formula will return 6: Get work hours between dates. Add business days to date. 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 , you can use the WORKDAY function.

In the example, the formula in D Get work hours between dates custom schedule. To calculate work hours between two dates with a custom schedule, you can use a formula based on the WEEKDAY and CHOOSE functions.

In the example shown, the formula in F8 is: List holidays between two dates. To list holidays that occur between two dates, you can use a formula based on the TEXTJOIN and IF functions.

Solid Excel Formula Training Learn Excel formulas and functions with clear, concise videos. I watched a few videos this morning and learned one key thing that will save me hours at work! Excel video training Quick, clean, and to the point.

Home About Blog Contact Feedback.