The NETWORKDAYS function is a date and time function which Calculates the number of valid working days between two dates inclusively. It counts based on a standard Monday-Friday workweek, and exceptions such as holidays can be added to the function.

This is the format of the NETWORKDAYS function:

=NETWORKDAYS(START DATE, END DATE, HOLIDAYS)

Here is an example of the NETWORKDAYS function:

=NETWORKDAYS(43903,43910) = 6

This function is valuable when calculating or tracking billable days of work, or project duration. As you are able to include holidays or other events which may be unique to your organisation it provides an increased flexibility over other more manual tracking methods.

An example of a functional implementation of this would be when managing a multi-step project, tracking the actual duration of tasks versus their planned/budgeted times, with or without the inclusion of a holiday calendar amounts to improve accuracy. Using the function to perform these counts will enable further dynamic (daily) statistics based on project status and financial position based on the current data.

ex: Start dates are in column B, Est. completion dates are in column C, Est. days to completion are in column D, and current time to completion are in column E

=NETWORKDAYS(B2, TODAY())