Hi people,

I think I'm having a brain freeze at the moment. This is bound to be really simple - I'm generating an aged debtors report and I need a formula to return one of three answers:

Overdue
Today Today
Not Due

If the number of days overdue is greater than 0, I need it to return '"Overdue." if the value is 0, to return "Due Today." If the value is minus, "Not Due."

Can anybody provide me with a quick formula to show this please?

Thanking you!

Lee.