Count Number of Monday between two dates

[Aswinraj]

Hello,

I need to find Number of Mondays inside dates provided.

Start date: 4/20/2020 and End Date: 5/18/2020 = Result: 5 ( Including both Start and End dates since both are Mondays)
Start date: 5/25/2020 and End Date: 6/15/2020 = Result: 4 ( Including both Start and End dates since both are Mondays)

But i am not getting it correctly. I tried below formula..,

=ED-SD-NETWORKDAYS.INTL(SD,ED,12)+1

 

[GraH]

Maybe,
=SUMPRODUCT((WEEKDAY((ROW(INDIRECT(StartDate&":"&EndDate)));2)=1)*1)

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
1	Start date: 4/20/2020 and End Date: 5/18/2020 = Result: 5 ( Including both Start and End dates since both are Mondays)
2	Start date: 5/25/2020 and End Date: 6/15/2020 = Result: 4 ( Including both Start and End dates since both are Mondays)
3
4
5		20/apr	18/mei	5
6		25/mei	15/jun	4
7
Sheet1

Cell Formulas
Range	Formula
D5:D6	D5	=SUMPRODUCT((WEEKDAY((ROW(INDIRECT(B5&":"&C5))),2)=1)*1)

 

[Peter_SSs]

But i am not getting it correctly. I tried below formula..,

=ED-SD-NETWORKDAYS.INTL(SD,ED,12)+1

That formula works for me for those dates. What start/end dates does it fail for?

BTW I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

20 04 21.xlsm
	A	B	C
1	Start	End	Mondays
2	20/04/2020	18/05/2020	5
3	25/05/2020	15/06/2020	4
Mondays

Cell Formulas
Range	Formula
C2:C3	C2	=B2-A2-NETWORKDAYS.INTL(A2,B2,12)+1

 

[Aswinraj]

@Peter_SSs Perfectly works as i wanted. Thank you so much.

 

[Peter_SSs]

@Peter_SSs Perfectly works as i wanted. Thank you so much.

No need to thank me as I didn't do anything - I just used your existing formula.
But I'm glad if it is working for you now.

(Don't forget to update your account details though.)

 

[Dave Patton]

T202004a.xlsm
	A	B	C	D
1	Start	End
2	20-Apr-20	18-May-20	5	5
3	25-May-20	15-Jun-20	4	4
4aa

Cell Formulas
Range	Formula
C2	C2	= SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(SD&":"&ED)))=2))
D2	D2	=NETWORKDAYS.INTL(SD,ED,"0111111")
C3	C3	= SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A3&":"&B3)))=2))
D3	D3	=NETWORKDAYS.INTL(A3,B3,"0111111")