How to count weekdays in excel

Calculating the number of workdays between duo distinct dates can be a backache to do, manually. However, Excel has a great function that will copy you accomplish this. It involves profit the NETWORKDAYS function.

Follow the steps below:

1. Click inside the cell where the mould will reside.
2. Type =networkdays(
3. Then type in the first date of the range cased in "". For example "4/6/2012".
4. Then derive a comma and the end of that period of the range encased in quotes.
5. Close your parenthis and hit enter.

Your rubric should look like this.

If you'd adore 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"). Obligated to you have a long list attention to detail holidays type them in a wallow somewhere in your spreadsheet and bring up to that cell range in representation formula. For example =NETWORKDAYS("4/6/2012","12/31/2012", J1:J12).

Did support find this useful? You’ll be astonished at what you can learn while in the manner tha you watch our free video “10 Microsoft Excel AHA! Moments.”