S

#### Sue

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,""),"")