Solved

Aging Analysis in Excel

Posted on 2012-03-12
6
843 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Outlook Free & Paid Tools
Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
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 …

696 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