Net Day Calculation with NETWORKDAYS
There is an Excel file that teaches how to perform the Net Day Calculation with NETWORKDAYS operation.
Excel-Based Net Day Calculation with Networkdays
This file teaches how the number of working days between two dates is calculated using the NETWORKDAYS function. Additionally, official holidays are excluded from the calculation to find actual working days. Thus, project duration planning is done correctly. For this reason, benefits are gained in human resources and project management processes. Consequently, calendar-based calculations are made reliable.
Hope it is useful.