Question

In cell H7, create a formula that uses the NETWORKDAYS function to calculate the number of working days between the dates in cells H5 and H6. Leave the Holidays argument blank

Answer 1

Answer:

=NETWORKDAYS(A1,A2)

Explanation:

To use NETWORKDAYS function, we make use of the syntax:

= NETWORKDAYS(begin_date,end_date,[holidays])

The argument in square bracket is optional.

Assume that cell H5 is the initial date and cell H6 is the final date, the above syntax will be implemented as:

=NETWORKDAYS(H5,H6)