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
SrirampriyaAsked:
Who is Participating?
 
AlanConsultantCommented:
Hi,

See attached for an example.

HTH,

Alan.
Ageing---Version-001.xls
0
 
jppintoCommented:
The "Age" is calculated how? Since the "submit date" until now?
0
 
jppintoCommented:
You have this already working, don't you?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
AlanConsultantCommented:
Yes - I believe so.

Alan.
0
 
jppintoCommented:
So...what do you need our help then?!?
0
 
SrirampriyaAuthor Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.