# Number of working days per month between 2 Dates

#### CurrentHamster

##### New Member
Good Afternoon,

I'm trying to find a formula that will count the number of working days per month between two dates.

I can do the number of working days per month between two dates (If "End Date is blank it calculates using the last day of the current month):
Formula in C2:
=IF(\$B2="",NETWORKDAYS(\$A2,EOMONTH(TODAY(),0)),NETWORKDAYS(\$A2,\$B2))
 A B C 1 Start Date End Date Full Time Equivalent 2 03/12/2018 02/01/2019 23 3 05/12/2018 07/01/2019 24 4 29/11/2018 197

<tbody>
</tbody>

I can also do the number of days per month betwen two dates:
 A B C D E 1 Start Date End Date Full Time Equivalent Dec-18 Jan-18 2 03/12/2018 02/01/2019 23 29 2 3 05/12/2018 07/01/2019 24 27 7 4 29/11/2018 197 31 31

<tbody>
</tbody>
=MAX(0,MIN(IF(\$b2="",TODAY(),\$b2),EOMONTH(DATEVALUE(D\$1),0))-MAX(\$A2,DATEVALUE(D\$1))+1)

But I can't seem to combine the two together so that e.g. E3 should be 5 because the Sat 4th and Sun 5th, I don't need to exclude Bank Holidays just weekends.

### Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

#### Mentor82

##### Active Member
Hi,
Try maybe calculationg network days where end date id.your end.date in column B but start dste would be date=last day of the month in column A sothat in E3 would be =Networkdays(31/12/2018,07/01/2018)

#### Mentor82

##### Active Member
Hi again,
I do not think the solution I recommended will work. In order to cslculate networkdays you need start and end dates. End date would be the one in column B but what should be your start date for row 2, 3 and 4 in your example?

#### Tetra201

##### MrExcel MVP
... E3 should be 5 because the Sat 4th and Sun 5th, I don't need to exclude Bank Holidays just weekends.
Try in E3

=NETWORKDAYS(MAX(\$A3,EOMONTH(DATEVALUE(E\$1),-1)+1),MIN(IF(\$B3="",TODAY(),\$B3),EOMONTH(DATEVALUE(E\$1),0)))

#### CurrentHamster

##### New Member
That works perfectly, thank you very much!

Replies
1
Views
106
Replies
1
Views
134
Replies
7
Views
76
Replies
3
Views
102
Replies
6
Views
150