Microsoft Office Tutorials and References
In Depth Information
NETWORKDAYS
NETWORKDAYS
NETWORKDAYS returns the number of working days between two dates. Excludes weekends
and specified holidays.
=NETWORKDAYS(start_date,end_date,holidays)
The NETWORKDAYS function allows you to find out the total number of working days between two
dates excluding the weekends and holidays. This is an extremely important function when
calculating schedules that have to be completed within specific time frames. Notice the
example in Figure 4.7, the first example in cell C9 is used to calculate actual working days between
two dates, the second example takes into account a third date, which is a holiday. The third
example takes on several holidays that fall between two dates in the form of cell referencing a
range of dates. If you exclude all holidays in a year, this would be the best approach, as well as
using the start and stop dates with cell referencing. Notice how in the 4th and last example the
structure is set up so you can apply a start date and an end date, and a range of holidays. The
cell referencing will automatically adjust to your inputs.
The date that represents the start date.
START DATE
The date that represents the end date.
END DATE
This is optional, however, you can use one or more holidays in the
form of text in the formula or in a range of cells.
HOLIDAYS
B
End date
A
Start date
Figure 4.7
The NETWORKDAYS
function allows you to
find the number of
working days between
two dates, excluding
weekends and holidays.
C
Apply holidays to
produce net
number of work
days.
Search JabSto ::




Custom Search