Calculating the number of workdays between two distinct dates can be a pain to do, manually. However, Excel has a great function that will help you accomplish this. It involves using the NETWORKDAYS function.
Follow the steps below:
- Click inside the cell where the formula will reside.
- Type =networkdays(
- Then type in the first date of the range encased in "". For example "4/6/2012".
- Then type a comma and the end date of the range encased in quotes.
- Close your parenthis and hit enter.
Your formula should look like this.
If you'd like to add in holidays add them as a new condition in {}. For example =NETWORKDAYS("4/6/2012","12/31/2012", {"7/4/2012", "12/25/2012"). Should you have a long list of holidays type them in a list somewhere in your spreadsheet and refer to that cell range in the formula. For example =NETWORKDAYS("4/6/2012","12/31/2012", J1:J12).
Did you find this useful? You’ll be amazed at what you can learn when you watch our free video “10 Microsoft Excel AHA! Moments.”
