How to Calculate Weekdays Between Two Dates in Excel

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:

1. Click inside the cell where the formula will reside.
2. Type =networkdays(
3. Then type in the first date of the range encased in "". For example "4/6/2012".
4. Then type a comma and the end date of the range encased in quotes.
5. 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.”