Do you have a column with the number of days overdue?

Are you just after an IF statement?

If you could just describe the key column headers i might be able to help.



"Jaleel" wrote:

A footnote:

I am expecting a response from Dave / Gord / Rag / Biff / Max / Garys / Bob
/ ????

With humble regards,

Jaleel

"Jaleel" wrote:

I have an Excel File with the range of A1:AR35. I need some formula in the
range AM6:AR35. The requirement is to get the results according to the
credit terms of the Clients like 30 days, 45 days, 60 days, 90 days and
whichever payment is overdue in the columns with the heading as follows:

Not Due "Overdue < 30 days" "Overdue30 - 60 days" "Overdue 60 - 90 days"
"Overdue 90 - 120 days" "Overdue 120 days"

It is a Client Position file, which I cannot describe through this. If
anybody can help me I can send the file through email. Please, it is
prestige issue.

Jaleel