Can any one help me pls with an Excel formula to determine the networkdays between multiple date ranges, without overlap and gaps.
Example:
Task 1 : Starts 1/4/2023 Ends 16/4/2023
Task 2 : Starts 15/7/2023 Ends 5/8/2023
Task 3 : Starts 1/8/2023 Ends 10/8/2023
Example:
Task 1 : Starts 1/4/2023 Ends 16/4/2023
Task 2 : Starts 15/7/2023 Ends 5/8/2023
Task 3 : Starts 1/8/2023 Ends 10/8/2023