Aging Function

About a year ago I had someone help me with a re-aging function. It essentially took a bad aging report and fixed it, via a function.

For example, if I had these values:

Please Login or Register  to view this content.

It would take the current and net it against the 91-120 to have only 99.00 in the 91-120. The code includes stuff for some odd situations, and apparantly there is a new one this year that throws off the calculation.

If I have these values:

Please Login or Register  to view this content.

The function is returning -128.80 in Current instead of -12.76 in current.

I believe it has something to do with the total amount due being less than zero and it throws off the calculation.

The way I use the above function is actually like an array...I would enter this formula into 6 cells and confirm with CTRL-SHIFT-ENTER:
=IF($S2=1,aging($I2:$N2),"")

Can someone review the code and possibly identify where it needs to be tweaked? I greatly appreciate it (the code grew beyond my comprehension last year, so I have difficulty figuring out exactly what it is doing).

Thanks!

Please Login or Register  to view this content.

One interesting note:

Although this doesn't work right:

Please Login or Register  to view this content.

If you change it around a bit it will work right:

Please Login or Register  to view this content.

Okay...with a really poor understanding of what this function is doing behind the scnenes I was able to inch my way through the code.

Snippit:

Please Login or Register  to view this content.

Towards the bottom I changed the 2 to a 1 because it sounded good and, voila, it fixed my problem. That being said, I have no idea if it was a proper fix (ie, it may have broken something else)...but it appears to work so I'm going to go with it for now .