Get work hours between dates

To calculate the total number of work hours between two dates, you can use a formula based on the NETWORKDAYS function, where "start" is the start date, "end" is the end date, "holidays" is a range that includes dates, and "hours" is the number of work hours in a workday. In the example shown, the formula in D7 is: =NETWORKDAYS(B7,C7,holidays)*8 where "holidays" is the named range G6:G8.

April 14, 2025 · 1 min · 71 words · Kimberly Torres

Table of Contents

Holidays, if provided, must be a range of valid Excel dates.

In these example shown, the first two formulas use the NETWORKDAYS function.

Custom work schedule

This formula assumes all working days have the same number of work hours.

Excel formula: Get work hours between dates and times

NETWORKDAYS automatically excludes weekends (Saturday and Sunday) and canoptionallyexclude a list of holidays supplied as dates.

…

NETWORKDAYS.INTL Function

The Excel NETWORKDAYS.INTL function calculates the number of working days between two dates.

Excel formula: Get workdays between dates

Excel formula: Add business days to date

Excel formula: Get work hours between dates custom schedule

Excel NETWORKDAYS function

Excel NETWORKDAYS.INTL function