Number of Sundays between dates

[chandrashekar]

Hello Team,

How to know number of Sundays between dates using formula

[TABLE="width: 297"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]SD[/TD]
[TD] ED[/TD]
[TD] No of Sundays[/TD]
[/TR]
[TR]
[TD="align: right"]4/6/2018 19:01[/TD]
[TD="align: right"]4/9/2018 23:01[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]4/1/2018 19:01[/TD]
[TD="align: right"]4/30/2018 22:01[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD="align: right"]4/6/2018 19:01[/TD]
[TD="align: right"]4/8/2018 21:01[/TD]
[TD="align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]
Regards,

Chandru

 

[mikerickson]

This worked for me
=INT((B1-A1)/7)+(WEEKDAY(A1,2)>WEEKDAY(B1,2))+(WEEKDAY(B1)=1)

 

[Dave Patton]

Excel 2010
	A	B	C	D
1	SD	ED	No of Sundays
2	06-Apr-18 7:01 PM	09-Apr-18 11:01 PM	1	1
3	01-Apr-18 7:01 PM	30-Apr-18 10:01 PM	5	5
4	06-Apr-18 7:01 PM	08-Apr-18 9:01 PM	1	1
5
2a

Cell Formulas
Range	Formula
C2	=NETWORKDAYS.INTL(A2,B2,"1111110")
D2	=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(INT(A2)&":"&INT(B2))))=1))

 

[kvsrinivasamurthy]

In C3

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(INT(A3)&":"&INT(B3))),1)=1))