Aged Dates Categorize

[richmcgill]

I need help with a formula or formulas to count and categorize aged dates based on the aging range below.
There is a fixed date at the top of the report that it will be compared to that is not a today formula.
There is a lot of information above and below where this information will be pulled from so a pivot table is not ideal.

Date

5/7/2019

5/20/2019

3/1/2019

4/15/2019

5/24/2019

5/29/2019

5/30/2019

6/7/2019

5/30/2019

6/3/2019

<tbody>
</tbody>

Populate count here.

Days On Report

0 Days 1-7 Days

8 to 14 Days

15 to 21 Days

22 to 29 Days

30 Days and Over

<tbody>
</tbody>

 

[CalcSux78]

Excel 2010

	C	D
1	Fixed Date	6/7/2019
2
3	Days On Report
4	0 Days	1
5	1-7 Days	1
6	8 to 14 Days	4
7	15 to 21 Days	1
8	22 to 29 Days	0
9	30 Days and Over	3

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula D4 =COUNTIF(A$2:A$11,$D$1) D5 =COUNTIFS(A$2:A$11,"<="&$D$1-1,A$2:A$11,">="&$D$1-7) D6 =COUNTIFS(A$2:A$11,"<="&$D$1-8,A$2:A$11,">="&$D$1-14) D7 =COUNTIFS(A$2:A$11,"<="&$D$1-15,A$2:A$11,">="&$D$1-21) D8 =COUNTIFS(A$2:A$11,"<="&$D$1-22,A$2:A$11,">="&$D$1-29) D9 =COUNTIF(A$2:A$11,"<="&$D$1-30) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

 

[richmcgill]

Thank you so much!!! This worked very well.

Thank you again!