Westonci.ca is the premier destination for reliable answers to your questions, provided by a community of experts. Discover a wealth of knowledge from experts across different disciplines on our comprehensive Q&A platform. Get detailed and accurate answers to your questions from a dedicated community of experts on our Q&A platform.

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

Sagot :

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)