Invoice Aging spreadsheet Formula for 120+ days see attachment

[ncmbilling]

I have a spreadsheet that I am manually tracking our Aging for our invoices we send to clients. Column B is the clients name, Column C is the job name, column D is the Job Number, Column E is the invoice Date, Column F is the Invoice Amount, Column G-K are aging columns; 0-30 days; 31-60 days, 61-90 days, 91-120 days and 121+ days. I have the folloing formula which is giving me aging for all of the columns except the fomula isn't working for 121+ days =$F6*(ROUNDUP((TODAY()-$E6)/30,0)=COLUMN(A$1))

Can someone help?

[Pepe Le Mokko]

Perhaps post a small simple sheet to see your layout

[ncmbilling]

Here is an example of my spreadsheet.New AR Tracker EXAMPLE.xls