LiamMcKay
asked on
Overdue Dates Formula in Excel
I am using Excel 2010. I have two rows in a spreadsheet that will contain dates. I want to have an overdue cell that displays the word Overdue when either of the dates in the row rows exceed today's date. I have tried on the attached sample, but the ovverdue text is always displaying. sample.xlsx
ASKER
When doing this, the Overdue text still displays when the other feilds are blank.
Try:
=IF(AND(COUNTA(B3:B4)=2,OR (B3<TODAY( ),B4<TODAY ())),"Over due", "")
=IF(AND(COUNTA(B3:B4)=2,OR
Change to this:
=IF(AND(B3<TODAY(),B3<>"") , "Overdue", "")
=IF(AND(B3<TODAY(),B3<>"")
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
=IF(B3<TODAY(), "Overdue", IF(B4<TODAY(), "Overdue"; ""))
To this:
=IF(B3<TODAY(), "Overdue", "")