How to calculate the number of working days in a month in Excel

See it work

The formula is already in B2, filled down to B6. Change any input and the result updates, or edit the formula to experiment.

How it works

In Google Sheets

The same formula works in Google Sheets: =NETWORKDAYS(EOMONTH(A2,-1)+1,EOMONTH(A2,0),$D$2:$D$6). We ran it in Google Sheets mode on the same data and it returns the same results.

Other ways to do it

Each one was run on the same example sheet.

Common mistakes

• With a mid-month date in A2, NETWORKDAYS(A2,EOMONTH(A2,0)) counts only the rest of the month. Start from EOMONTH(A2,-1)+1 for the whole month.
• A holiday on a weekend doesn't reduce the count. List the observed weekday instead, like July 3, 2026 for Independence Day.

Try it yourself

Same data, empty answer cell. Your formula is graded instantly, then re-checked on changed data, so a typed-in number won't pass.

Related answers

• How to calculate how many days of a date range fall in each month in ExcelOverlap the range with each month: =MAX(0,MIN($B$2,EOMONTH(D2,0))-MAX($B$1,D2)+1), with the month's first day in D2.
• How to add months to a month-end date and stay at the end of the month in ExcelUse =EOMONTH(A2,B2). It adds the months and always returns the last day of the resulting month.
• How to calculate a due date with Net 30 end-of-month terms in ExcelStart the count at the end of the invoice month: =EOMONTH(B2,0)+30.
• How to calculate month-to-date (MTD) sales in ExcelUse SUMIFS from the first of the month to the as-of date: =SUMIFS(C2:C10,A2:A10,">="&EOMONTH(F1,-1)+1,A2:A10,"<="&F1).
• How to calculate the days remaining in the month in ExcelSubtract the date from the month end: =EOMONTH(A2,0)-A2.
• How to calculate the first of the month after 60 days in ExcelAdd the waiting period, go to that month's end and add a day: =EOMONTH(B2+$F$1,0)+1, with 60 in F1.

Functions used: NETWORKDAYS · EOMONTH

Lessons: EDATE, EOMONTH & NETWORKDAYS (Pro)