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
Microsoft ApplicationsMicrosoft Office
Last Comment
Srirampriya
The "Age" is calculated how? Since the "submit date" until now?
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
You have this already working, don't you?
Yes - I believe so.
Alan.
Alan.
So...what do you need our help then?!?
ASKER
Thanks