Solved

Aging Analysis in Excel

Posted on 2012-03-12
6
811 Views
Last Modified: 2012-03-12
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
0
Comment
Question by:Srirampriya
  • 3
  • 2
6 Comments
 
LVL 33

Expert Comment

by:jppinto
ID: 37709024
The "Age" is calculated how? Since the "submit date" until now?
0
 
LVL 12

Accepted Solution

by:
Alan3285 earned 500 total points
ID: 37709068
Hi,

See attached for an example.

HTH,

Alan.
Ageing---Version-001.xls
0
 
LVL 33

Expert Comment

by:jppinto
ID: 37709091
You have this already working, don't you?
0
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 
LVL 12

Expert Comment

by:Alan3285
ID: 37709132
Yes - I believe so.

Alan.
0
 
LVL 33

Expert Comment

by:jppinto
ID: 37709152
So...what do you need our help then?!?
0
 

Author Closing Comment

by:Srirampriya
ID: 37709539
Thanks
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
My experience with Windows 10 over a one year period and suggestions for smooth operation
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now