Calculate the number of work days between two dates in Excel

Who else wants to know the secret to Excel Formulas?

Invest in yourself in 2015 and reduce your frustration with formulas in Excel for just $19.95 - Click here to enroll today

Ever wondered how many work days there are between two dates?  Maybe you are counting down the number of days you have left in the office before your big holiday?  Maybe you just need to know how many days you have until that project is due?  Whatever the reason, using Excel you can calculate the number of business days between two dates.

To do so, we will use the NETWORKDAYS formula.

  1. Type the two dates you want to calculate the number of days betwen into Excel – in one cell type the date you want to calculate from, and the other cell the date you want to calculate to
  2. In another cell, type =NETWORKDAYS(
  3. Select the first cell – if you typed the first date in A1 the formula will now look like =NETWORKDAYS(A1
  4. type a comma
  5. Select the second cell – if you typed the second date in B1 the formular will now look like =NEWWORKDAYS(A1,B1
  6. Type the closing bracket to complete the formula – it will now look like =NETWORKDAYS(A1,B1)
  7. Hit enter!

There you have it, the number of days you need to wait until you go away, or the number of days to countdown until that deadline!

’till next time!

Leave a Reply

Your email address will not be published. Required fields are marked *