Question:     How can I calculate the number of workdays between two dates? The usual off days are Saturday, Sunday and public holidays.

Answer:        By using the Networkdays function


Why:            To calculate the number of workdays between two dates                   


Applies To: Excel (2010, 2007):


1.         The data below will be used for illustration purposes









2.         Select cell A7

3.       Select Formulas>Date & Time>NETWORKDAYS.  Refer to the screen shot below











4.         Enter as below and select Ok








The number of workdays between the two given dates is 78.  The formula can also be entered in this way;


=NETWORKDAYS (A3,A4,A5:A6).  The formula subtracts the usual weekend days and any specified holidays from the difference between the start and end dates of the project.