Modification in the formula

kshitij_dch

Active Member
Joined
Apr 1, 2012
Messages
335
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

Well-known Member
Joined
Sep 21, 2016
Messages
2,673
=mod(countif(c24:c523,">=1/4/2019")-countif(c24:c523,">30/9/2019")-1,k7)+1
 

Forum statistics

Threads
1,082,604
Messages
5,366,581
Members
400,904
Latest member
ndaines meriabi

Some videos you may like

This Week's Hot Topics

Top