• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 865
  • Last Modified:

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
0
Srirampriya
Asked:
Srirampriya
  • 3
  • 2
1 Solution
 
jppintoCommented:
The "Age" is calculated how? Since the "submit date" until now?
0
 
AlanConsultantCommented:
Hi,

See attached for an example.

HTH,

Alan.
Ageing---Version-001.xls
0
 
jppintoCommented:
You have this already working, don't you?
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
AlanConsultantCommented:
Yes - I believe so.

Alan.
0
 
jppintoCommented:
So...what do you need our help then?!?
0
 
SrirampriyaAuthor Commented:
Thanks
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now