LinkBack URL
About LinkBacks
Dear all,
Could any one help how to get the result of attached format.
I m looking the aging of my invoice date for attached format.
I have tried many formulas, but i think format is different or what?
Thanks for advance
How to get aging days from the dates for attached format
Dear all,
Could any one help how to get the result of attached format.
I m looking the aging of my invoice date for attached format.
I have tried many formulas, but i think format is different or what?
Thanks for advance
Last edited by tariqnaz2005; 05-26-2015 at 09:02 AM.
hi tariqnaz. the dates in column E are not recognized as dates in Excel.
you can select the range E1:E2 & press CTRL + SHIFT + ~
you should see all of them become numbers if they are real dates. Undo it to revert to normal.
select the range again. go to Data -> Text to Column -> Delimited -> Next -> Next -> Date: MDY -> Finish.
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
It looks like the formulas are returning the correct values. They are subtracting the earlier date from the later date.
What values are you expecting to see?
Column E is text not a date, and even if it was a date it is in a different format to column G, though that doesnt really matter.
Use this:
in J1
=G1-DATE(RIGHT(E1,4),LEFT(RIGHT("0"&E1,10),2),MID(RIGHT("0"&E1,10),4,2))
and copy down
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
OR,
Try the following formula in J1:
=TODAY()-DATE(RIGHT(E1,4),LEFT(E1,SEARCH("/",E1,1)-1),MID(E1,SEARCH("/",E1,1)+1,2))
Thank you very much all of you for your quick reply,
@Ron Coderre.. I want days (from invoice date till today)
@Special-K - your formula worked but its giving me error if the date format of column is "4/5/2015" but if the format is 4/15/2015 than answer is correct
@CBatrody - same issue like special_K
pls help again.
Is the date format dd/mm/yyyy or mm/dd/yyyy?
@cBATRODAY... sir, it is text not date format.. you can see my first attachment.
any way, the formual =TODAY()-DATE(RIGHT(E1,4),LEFT(E1,SEARCH("/",E1,1)-1),MID(E1,SEARCH("/",E1,1)+1,2)) is working for me.
i have to just change =TODAY()-DATE(RIGHT(E1,4),LEFT(E1,SEARCH("/",E1,1)-1),MID(E1,SEARCH("/",E1,1)+1,1)) like this.
thanks for your help.
This thread is closed.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks