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:
- 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).
Tags: Excel Tips, Free Excel Tip, Microsoft, Microsoft Excel 2010, Microsoft Office, Office
