LinkBack URL
About LinkBacks
HI
Any one can teach me how to calculate aging, from the date created to current date.
Aging Type:
Less Than 7 days
Less Than 15 days
Less Than 30 days
More than 30 days
Thank You
Regards
Rashim
Aging Formula
HI
Any one can teach me how to calculate aging, from the date created to current date.
Aging Type:
Less Than 7 days
Less Than 15 days
Less Than 30 days
More than 30 days
Thank You
Regards
Rashim
Last edited by rashim; 12-12-2010 at 10:11 PM.
To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.
If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.
Doing this will ensure you get the result you need!
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Possibly:
=TODAY()-"date created"
If you want to allocate a date into one of those categories then with date in A1 try this formula
=IF(A1="","",LOOKUP(TODAY()-A1,{0,7,15,30;"Less Than 7 days","Less Than 15 days","Less Than 30 days","More than 30 days"}))
Audere est facere
Thank You Guys
Hi daddylonglegs , thank you very much it's working very fine..
Hi i have attach the sample database, is it possible to add another function if there is an close date the column should show within how many days the case has been close.
In a column labeled Days Closed
=IF(ISNUMBER(E3),TODAY()-E3,"") dragged down.
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Hi ChemistB
it's not working,
Are you looking to get a range like before or just a # of days closed? What is "not working?" Give an example of what you expect and what you're getting. Thanks
currentlly under the aging colum it has been stated the aging type such as , "Less Than 7 days","Less Than 15 days","Less Than 30 days","More than 30 days, if there in an close date stated (Under Close date colum ) then the aging colum should not show the aging type but it should show within how many days the case has been close
is it possible to put 2 VLOOKUp ?
If you mean you want the number of days from Date Created to Date Closed to appear in the Aging column then replace the formula in cell G3 with this amended one:
and drag down
Please Login or Register to view this content.
Re: Aging Formula
Thank You Very much guys..its work fine
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks