Solved

Aging Analysis in Excel

Posted on 2012-03-12
6
823 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
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

776 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