In cell H7, create a formula that uses the NETWORKDAYS function to calculate the number of working days between the dates in cel

Question

3 years ago

9

ls H5 and H6. Leave the Holidays argument blank

1 answer:

Nesterboy [21] · Answer 1 · 2022-05-16T05:53:07+03:00

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)