COUNTIFS help

[DRWonoski]

I'm having an issue with a countifs formula that I'm trying to get. I need a formula to see how many rows items meet the following criteria

• End date is before Reference Date
• Start Date is before Reference Date + 6 days
• Difference between Start Date and End date is less than 30 days

Item	Start Date	End Date	Reference Date
1	12/1/2016	12/9/2016	12/10/2016
2	12/2/2016	12/20/2016
3	12/10/2016	12/12/2016
4	12/14/2016	12/16/2016

<tbody>
</tbody>

=COUNTIFS(
CRITERIA 1 -

B:B,">"&C4

CRITERIA 2 -

A:A,"<"&C4+6

CRITERIA 3 -

A:A,& ????????????

Any help would be greatly appreciated.

 

[Tetra201]

This?

=COUNTIFS(B:B,"<"&C4,A:A,"<"&C4+6,A:A,">"&B4-30)