Number of working days per month between 2 Dates

CurrentHamster

New Member
Joined
Dec 10, 2018
Messages
4
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.
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Mentor82

Active Member
Joined
Dec 30, 2018
Messages
307
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
Joined
Dec 30, 2018
Messages
307
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?
 

Watch MrExcel Video

Forum statistics

Threads
1,095,369
Messages
5,444,060
Members
405,264
Latest member
JohnP1972

This Week's Hot Topics

Top