Move to diferent cell using date as reference

**deepdiver** · 09-28-2007, 02:25 PM

I’m new in excel and I hope this is the right forum.
I have a collection report spreadsheet and in the cell B4 I have the date of the sale, and B5 the amount of debt, and in cell B6 the debt between 0 to 30 days, B7 31 to 60 days and B8 61 to 90 days, and B9 90 days and above. How can I do to move automatic the debt to the next column when is getting older

Thanks

**VBA Noob** · 09-28-2007, 02:54 PM

Maybe

=IF(AND(TODAY()-$B4>=0,TODAY()-$B4<=30),$C4,"")

=IF(AND(TODAY()-$B4>30,TODAY()-$B4<=60),$C4,"")

=IF(AND(TODAY()-$B4>60,TODAY()-$B4<=90),$C4,"")

VBA Noob

**deepdiver** · 09-30-2007, 02:13 PM

Thanks for your reply, but when I used the formulas it displayed me an error formula box. I want to know if there is something missing in the formula.

Thanks again

Deepdiver