Count the number of Wednesday between 2 given date

[pivotpp]

Hi all,


My goal is to count the number of a specific day of the week, say a Wednesday or Friday or Sunday between Date 1, say 1/10/2017 and Date 2, say 8/10/2017.


A1: 1/10/2017


A2: 8/10/2017


Any thoughts on a formula to being able to count the number of specific day of the week between them?


Thanks in advance

 

[MisterProzilla]

=INT((WEEKDAY($A1-4)+$A2-$A1)/7)

Where 4 is the weekday (0 = Sunday to 6 = Saturday)

 

[Nishant94]

Unknown
	A	B	C
1	Date 1	Date 2	No. of Wed
2	30/10/2017	16/10/2017	2
3	01/10/2017	08/10/2017	1
4	24/05/2017	31/07/2017	10
Sheet16

Cell Formulas
Range	Formula
C2	=SUMPRODUCT(--(TEXT(ROW(INDIRECT(A2&":"&B2)),"ddd")="Wed"))