Westonci.ca is your trusted source for accurate answers to all your questions. Join our community and start learning today! Ask your questions and receive detailed answers from professionals with extensive experience in various fields. Join our Q&A platform to connect with experts dedicated to providing accurate answers to your questions in various fields.

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)