Aging Formula


S

Sue

Have the following formula for aging, would like for it to age credit
balances in the current column. Can I add something to these formulas to
make it work

Cell Q1 is date to age from, Cell G2 is invoice date, cell H2 is invoice
balance.

formula for Current column
=IF($Q$1>=($G2+1),IF($Q$1<=($G2+30),$H2,""),"")

formula for 1-30 Days Past Due
=IF($Q$1>=($G2+31),IF($Q$1<=($G2+60),$H2,""),"")
 
Ad

Advertisements

F

Fred Smith

What's wrong with what you have? It looks like a decent aging formula to me.

Regards,
Fred.
 
S

Sue

I need to be able to tell if it the amount in cell H2 is less than 0(and
greater than 0) it goes in current column, in all the other aging columns the
amount has to be greater than 0
 
F

Fred Smith

So if H2 is less than zero, or the age is less than 31 days, it's current,
right? If so, try:

=if(or($h2<=0,$q$1<=$g2+30),$h2,"")

In the aging columns, try:

=if(and($h2>0,$q$1>$g2+30,$q$1<=$g2+60),$h2,"")

Regards,
Fred.
 
Ad

Advertisements

Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel A CountIF question... I think 2
macro ignore formulas 3
How do I add a formula to a macro? 4
CountIf with And 0
Nested IF Formula 5
Problem with SUMPRODUCT 6
Double If Statement help 2
Date Formula 85 factor 7

Top