I was using the aging formula from another post, and all was fine until the last row which should have been reported in the >1 year column. SeeAging.xlsx attached.
Can anyone help?
Cheers
Rob
I was using the aging formula from another post, and all was fine until the last row which should have been reported in the >1 year column. SeeAging.xlsx attached.
Can anyone help?
Cheers
Rob
The last row has a date of 20/07/2011 which is 9 months aged from the current month. So it should show up in the 7-12 months column right?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Yes, you are right! However the figure doesn't appear there either...
must be a problem with the last row because I changed the date of the next row up and the aging worked just fine.
Last edited by robbiehall; 04-25-2012 at 06:58 AM.
Your formula is not working correctly when there are any 2011 dates in it. It needs to be changed to something that is flexible.
What happened? You suddenly marked it solved?
Yes, if I use the row above the final row then the formula works with a 2011 date as well as 2012 - in fact I just tried it with a 2010 date and that worked too.
I spoke to soon, there are some 2011 dates that won't work with the formulas. Anybody got any ideas?
How can the formula be changed?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks