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.



[TABLE="width: 0"]
<tbody>[TR]
[TD]Date
[/TD]
[/TR]
[TR]
[TD]5/7/2019
[/TD]
[/TR]
[TR]
[TD]5/20/2019
[/TD]
[/TR]
[TR]
[TD]3/1/2019
[/TD]
[/TR]
[TR]
[TD]4/15/2019
[/TD]
[/TR]
[TR]
[TD]5/24/2019
[/TD]
[/TR]
[TR]
[TD]5/29/2019
[/TD]
[/TR]
[TR]
[TD]5/30/2019
[/TD]
[/TR]
[TR]
[TD]6/7/2019
[/TD]
[/TR]
[TR]
[TD]5/30/2019
[/TD]
[/TR]
[TR]
[TD]6/3/2019
[/TD]
[/TR]
</tbody>[/TABLE]


Populate count here.

[TABLE="width: 0"]
<tbody>[TR]
[TD]Days On Report
[/TD]
[/TR]
[TR]
[TD]0 Days
1-7 Days
[/TD]
[/TR]
[TR]
[TD]8 to 14 Days
[/TD]
[/TR]
[TR]
[TD]15 to 21 Days
[/TD]
[/TR]
[TR]
[TD]22 to 29 Days
[/TD]
[/TR]
[TR]
[TD]30 Days and Over
[/TD]
[/TR]
</tbody>[/TABLE]

 

[CalcSux78]

Excel 2010

	C	D
Fixed Date
Days On Report
0 Days
1-7 Days
8 to 14 Days
15 to 21 Days
22 to 29 Days
30 Days and Over

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: right"]6/7/2019[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]

[TD="align: right"][/TD]

[TD="align: center"]4[/TD]

[TD="align: right"]1[/TD]

[TD="align: center"]5[/TD]

[TD="align: right"]1[/TD]

[TD="align: center"]6[/TD]

[TD="align: right"]4[/TD]

[TD="align: center"]7[/TD]

[TD="align: right"]1[/TD]

[TD="align: center"]8[/TD]

[TD="align: right"]0[/TD]

[TD="align: center"]9[/TD]

[TD="align: right"]3[/TD]

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D4[/TH]
[TD="align: left"]=COUNTIF(A$2:A$11,$D$1)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D5[/TH]
[TD="align: left"]=COUNTIFS(A$2:A$11,"<="&$D$1-1,A$2:A$11,">="&$D$1-7)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D6[/TH]
[TD="align: left"]=COUNTIFS(A$2:A$11,"<="&$D$1-8,A$2:A$11,">="&$D$1-14)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D7[/TH]
[TD="align: left"]=COUNTIFS(A$2:A$11,"<="&$D$1-15,A$2:A$11,">="&$D$1-21)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D8[/TH]
[TD="align: left"]=COUNTIFS(A$2:A$11,"<="&$D$1-22,A$2:A$11,">="&$D$1-29)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]D9[/TH]
[TD="align: left"]=COUNTIF(A$2:A$11,"<="&$D$1-30)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[richmcgill]

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

Thank you again!