WHAT FORMULA DO I USE FOR AGING A STATEMENT

[ewalbers]

I am trying to age a statement for current - 31 to 60 days - 61 to 90 days
and over 90. How do I get excel to figure out which amount goes in what
column?

[Otto Moehrbach]

Are you saying that you want a formula to give you a date that is a fixed
number of days from some other date? If A1 has a date and you want a date
60 days from that date placed in B1, us this formula in B1: =A1+60. HTH
Otto
"ewalbers" <[email protected]> wrote in message
news:[email protected]...
>I am trying to age a statement for current - 31 to 60 days - 61 to 90 days
> and over 90. How do I get excel to figure out which amount goes in what
> column?
>