Modification in the formula

kshitij_dch

Active Member
Joined
Apr 1, 2012
Messages
336
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!! :)
 

Some videos you may like

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

footoo

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

Watch MrExcel Video

Forum statistics

Threads
1,095,711
Messages
5,446,097
Members
405,379
Latest member
EDGOUG

This Week's Hot Topics

Top