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
<tbody>
</tbody>
=COUNTIFS(
CRITERIA 1 -
CRITERIA 2 -
CRITERIA 3 -
Any help would be greatly appreciated.
- 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 -
Code:
B:B,">"&C4
Code:
A:A,"<"&C4+6
Code:
A:A,& ????????????
Any help would be greatly appreciated.