Excel 2003- Date- Find Working Days in Excel

Date

NETWORKDAYS calculates how many business days fall between two dates. This function, which you can only access if you’ve installed the Analysis ToolPak, finds the difference between two dates, excluding weekends. Optionally, you can have Excel exclude holidays, as well. However, because Excel doesn’t have a clue which dates you consider holidays, you have to develop a list in your worksheet with this information.

The basic syntax for the NETWORKDAYS function is: =NETWORKDAYS(Start Date,End Date,Holidays). With that in mind, let’s imagine that you want to find how many business days there are in January. First, enter the dates for January holidays as a list in A2:A3. Next, enter the start (1/1/2006) and ending (1/31/2006) dates in cells A9 and B9. Finally, click in the cell where you want to place the function (C9) and then type the function =NETWORKDAYS(A9,B9,A2:A3). If you set up the worksheet correctly, Excel should calculate 21 working days in January 2006.