Modification in the formula

[kshitij_dch]

Hello Folks ,

I am working on a file where in i am setting control limits "Upper Control Limit" and "Lower Control Limit" Sheet is working fine for me however need a small logic to be build in the below formula .

=MOD(COUNTA(C24:C523)-1,K7)+1

In the above Formula "C24:C523 is the range where Dates are saved, Currently the above formula is taking all the dates coming in range C24:C523.

I need above formula should only Take Date between "01st April 2019 till 30th September 2019" from the range C24:C523.

Need assistance and thanks in anticipation!!

 

[footoo]

=mod(countif(c24:c523,">=1/4/2019")-countif(c24:c523,">30/9/2019")-1,k7)+1