Formula Problem

[Kentexpress]

I have a formula problem which is driving me mad, any help would be appreciated. I have three columns with the below column titles & the data in the cell numbers in in brackets (A2, B2, C2)

(Cell A2) Required Return Date: (filled with a date for example 13-03-2021), B2 - Received Date, C2 - Overdue Status

If the goods are late and have not been received yet the cell ‘Received Date’ is blank. I would like the ‘Overdue Status’ cell to show as OVERDUE, if the ‘Received Date’ is later than the ‘Required Return Date’ .

However, if the ‘Required Return Date’ is still equal or early than its stated due date, I would like the cell ‘Overdue Status’ to show as DUE FOR RETURN.

 

[Joe4]

Welcome to the Board!

Try this formula in cell C2:

=IF(B2="","OVERDUE",IF(B2>A2,"REQUIRED RETURN DATE",IF(B2<=A2,"DUE FOR RETURN","")))

You weren't quite clear on what you want returned to the cell if B2>A2 (the part of the formula in red), so change that to whatever you want it to say.

 

[Kentexpress]

Top Man, thank you so much!

 

[Joe4]

You are welcome.
Glad I was able to help!

 

[Kentexpress]

I seem to have one small problem when there is a later date is in A2 'Required Return Date' for example 06/06/2021 & a blank in cell in B2 the C3 cell is showing OVERDUE. This isn't correct as the item isn't expected until 06/06/2021. The C3 cell should only show OVERDUE if the item has not been received beyond the A2 date. Please can anyone help?

 

[Joe4]

I seem to have one small problem when there is a later date is in A2 'Required Return Date' for example 06/06/2021 & a blank in cell in B2 the C3 cell is showing OVERDUE. This isn't correct as the item isn't expected until 06/06/2021. The C3 cell should only show OVERDUE if the item has not been received beyond the A2 date. Please can anyone help?

Try this version:

=IF(AND(A2<=TODAY(),B2=0),"OVERDUE",IF(B2>A2,"REQUIRED RETURN DATE",IF(AND(B2<=A2,B2>0),"DUE FOR RETURN","")))

 

[Kentexpress]

It works great, super speedy reply. Thanks again!