Srirampriya
asked on
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
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
The "Age" is calculated how? Since the "submit date" until now?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You have this already working, don't you?
Yes - I believe so.
Alan.
Alan.
So...what do you need our help then?!?
ASKER
Thanks