Solved

Aging Analysis in Excel

Posted on 2012-03-12
6
826 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
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
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…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

839 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