Business Day Calculation

An Excel file that teaches how to perform Business Day Calculation operation.

Excel Spreadsheet for Business Day Calculation

Start and end dates are entered. Weekends are automatically excluded. A separate table is kept for public holidays. A logic similar to NETWORKDAY is established with a formula. The result is reported in a single cell.

Hope it is useful.