Building a Formula

[cjgrafixdesign]

HELP :D

I'm building a formula that would find between two dates and SUM which if found this on your site very useful formula

=COUNTIFS(AH9:AJ60,">="&AA64,AH9:AJ60,"<="&AF64)

The formula helps me find all the dates I needed to count within certain worksheets.

for example I have this

START DATE (OCTOBER 1, 2018)
END DATE (OCTOBER 31, 2018)

Within 12 worksheet it did find all dates between October 1 to October 31.



however, i'd like to ask if .. it is possible for a formula that aside from finding those dates between. is it possible to have it SUM/DIFF into another date and it will only COUNTIF if it is greater than 3.


example data:

A<strike></strike>	B<strike></strike>	C <strike></strike>
DESCRIPTION<strike></strike>	DATE FILE <strike></strike>	DATE PROCESS <strike></strike>
APPLE <strike></strike>	10/05/2018 <strike></strike>	10/10/2018 <strike></strike>
GRAPES<strike></strike>	11/05/2018 <strike></strike>	11/10/2018 <strike></strike>
ORANGE<strike></strike>	12/05/2018	12/05/2018 <strike></strike>

<tbody>
</tbody>

=COUNTIFS(AH9:AJ60,">="&AA64,AH9:AJ60,"<="&AF64) NOTE: not the actual cell num

using the above formula will find the October, using column DATE PROCESS....after finding the date is it possible to also test C-B (as long as it is under October) and will only display a value greater than 3 days

sorry for my first post newbies here :D

 

[steve the fish]

If ive understood try this with the 1st october in E1:

=SUMPRODUCT(--($C$2:$C$4>=$E$1),--($C$2:$C$4 < EDATE(E1,1)),--($C$2:$C$4-$B$2:$B$4>3))<edate(e1,1)),--($c$2:$c$4-$b$2:$b$4></edate(e1,1)),--($c$2:$c$4-$b$2:$b$4>

 

[cjgrafixdesign]

A	B	C	D
Document Registered	Date Filed	Date Process	No. of Days Process Greater Than 3
DRRR	02/01/2018	02/07/2018	5​
ATTENDANCE	02/02/2018	02/03/2018
GATEPASS	02/03/2018	02/10/2018	7​
LEAVE FORM	05/01/2018	05/05/2018	​
TRAVEL ORDER	05/22/2018	05/23/2018
START	END	TOTAL
February 1, 2018	February 28, 2018	3

<tbody>
</tbody>

=COUNTIFS(C2:C6,">="&A9,C2:C6,"<="&B9)

Using the above formula will help me locate all FEBRUARY 2018 dates.

now, in the column of D2-D6 are results of difference between C-B only if they are under FEBRUARY and it is greater than 3