Explore Westonci.ca, the leading Q&A site where experts provide accurate and helpful answers to all your questions. Join our Q&A platform and get accurate answers to all your questions from professionals across multiple disciplines. Explore comprehensive solutions to your questions from a wide range of professionals on our user-friendly 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)