Count data between dates

[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 .

=COUNTA(C24:C$523)

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

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

Need assistance and thanks in anticipation!!

 

[Joe4]

Take a look at using the COUNTIFS formula.
See: https://exceljet.net/formula/count-cells-between-dates