Hi,

I have a worksheet that includes amongst it's fields an invoice created date (dd/mm/yy) and an invoice status field that is text with two options paid or unpaid.

I am trying to create a function in another cell to highlight any overdue dates (i.e. OVERDUE in text) based on whether the invoice created date is older than 28 days from todays date plus the invoice status field equals unpaid. I can do the first part with no issues but I am at a loss how to include the equals unpaid status in the function. The fields are on the same row i.e. G2 fro the invoice created date and K2 for the invoice status.

Any pointers?

Thanks,

Tom