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