Dates account 30 - 60 days over due

[ianmb]

I am finding a problem with the attached statement of account. “Original Data” is the first one I made and “NEW” is the version that I got from a member of Excel Forum (thanks vandanavai)
The difficulty is this – if an invoice is neither 30 days or 60 days overdue, with which amount is this added – to the 30 days or to the 60 days?
Also in “New Tab” I have dated an invoice 27/03/11 but it is being listed under the 60days, even though exactly 30 days have passed.
How can this be corrected?

Thanks

[scottylad2]

I am finding a problem with the attached statement of account. “Original Data” is the first one I made and “NEW” is the version that I got from a member of Excel Forum (thanks vandanavai)
The difficulty is this – if an invoice is neither 30 days or 60 days overdue, with which amount is this added – to the 30 days or to the 60 days?
Also in “New Tab” I have dated an invoice 27/03/11 but it is being listed under the 60days, even though exactly 30 days have passed.
How can this be corrected?

Thanks

Your maths out a little, =Today()-27/03/2011 results in 31 days, not 30, There are 31 days in march, 27 from 31 = 4 and 27 so far in April 27 + 4 =31

If an invoice is less than 30 days due it will go into 30, you can write an if around your sumif to state that if the debit date is greater than today leave blank, otherwise it will stay in the 30 till the date is greater than 30 past due

[ianmb]

Hi thanks for your reply. Can you pls give an example of the formula you recommended as I cannot get it to work
thanks

[scottylad2]

try this maybe

[ianmb]

HI scottylad2, thanks a lot for your help.