Aging report count dates

Firstly set up some check cells, lets say:<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
B1: =TODAY()+30<o></o>
B2: =TODAY()+60<o></o>
B3: =TODAY()+90<o></o>
<o> </o>
Then you can use the following formulas to count:<o></o>
<o> </o>
Current: =COUNTIF(A:A,"<="&B1)<o></o>
>30: =COUNTIF(A:A,">"&B1)<o></o>
>60: =COUNTIF(A:A,">"&B2)<o></o>
>90: =COUNTIF(A:A,">"&B3)<o></o>
<o> </o>
Hope that helps.<o></o>

Hi thanks for the info..but didn't quite work

I tried your suggestion and it puts all the 29 entries in A column under current and zero for >30 >60 >90.

Any other suggestions?

How do you define these ranges. Which dates fall into the category "Current" as of today? Which dates are ">30"?

Hi Barry

Basically what I have is one spreadsheet that is a list of IT related issues...so just simple records that have Date Problem was identified (column A), Record ID (B), record type (c), Probem Summary (e) etc

In a separate executive summary sheet, I want to generate a report that will reference the open problem sheet and count how many of the total records are over 90 days old, over 60 days, over 30 days and how many our current. I want this to generate based on current date so how many as of today are >90, >60 etc. The fate values in the source sheet do not change..they are static

All I need is a simple count (ie if i have 100) total records listed in open problem sheet...I want to see how many fall into each category

Geoff_canada said:

Hi thanks for the info..but didn't quite work

I tried your suggestion and it puts all the 29 entries in A column under current and zero for >30 >60 >90.

Any other suggestions?

Click to expand...

I'm not sure I understand the results that you have explained, unless I have mis-understood what you mean by >30, etc. I took this to be 30 days.

So current is any date that is 30 days old or later?

So for >90 in C1

=COUNTIF(A:A,"<"&TODAY()-90)

>60 in C2

=COUNTIF(A:A,"<"&TODAY()-60)-C1

>30 in C3

=COUNTIF(A:A,"<"&TODAY()-30)-SUM(C1:C2)

Current in C4

=COUNT(A:A)-SUM(C1:C3)

Great that worked....thanks again