Flagging Overdue date based on two fields

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

Hi

Many thanks for that. Appreciated.

I was just about to post that I found a similar solution posted elsewhere which I will post here if that will help anyone as it is slightly different to yours.

=IF(AND(U2="Unpaid", TODAY()-G2>28), "overdue","")

Thanks again.