The number of weekdays between two dates can be calculated using the Networkdays function.
Click in the cell where the answer goes and then, on the Formula bar, click the Insert Function
Fx button. The Insert Function dialog box will be displayed.
From the Or select a category drop-down list, select Date & Time. In the Select a function list, click on the NETWORKDAYS function and click OK.
The Function Arguments dialog box appears. In the Start_date entry type in the cell reference of the earlier of the two dates, then in the End_date field, type in the cell reference of the later date. Click OK. The numbers of working days is calculated and displayed.
Optionally, it is possible to specify a range holiday dates when using the NETWORKDAYS function. This allows the calculation of the number of working days between two dates. Should you have to do this regularly, then you may want to consider keeping a spreadsheet containing an up-to-date list of holidays and referencing this.
Find more information about our Microsoft Excel training courses Sydney, Australia.