We help IT Professionals succeed at work.

Aging Analysis in Excel

Hi

I want to calculate aging analysis using excel without the need to use VBA/scripting

I have the following columns

1. submit date
2. closed date

I want the aging displayed like this for all items which do not have closed date

The output can also be displayed in a new sheet

Age                    total
0-7                   12
8-15                  15
16-30                20
31-45       
46-60       
61-90       
>90       

Your help is appreciated

Regards
Comment
Watch Question

Commented:
The "Age" is calculated how? Since the "submit date" until now?
Consultant
CERTIFIED EXPERT
Commented:
Hi,

See attached for an example.

HTH,

Alan.
Ageing---Version-001.xls

Commented:
You have this already working, don't you?
AlanConsultant
CERTIFIED EXPERT

Commented:
Yes - I believe so.

Alan.

Commented:
So...what do you need our help then?!?

Author

Commented:
Thanks