WHAT FORMULA DO I USE FOR AGING A STATEMENT

E

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?
 
O

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
 
Top