• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1541
  • Last Modified:

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
0
LiamMcKay
Asked:
LiamMcKay
  • 3
1 Solution
 
jppintoCommented:
Please change your formula on cell B7 from this:

=IF(B3<TODAY(), "Overdue", IF(B4<TODAY(), "Overdue"; ""))

To this:

=IF(B3<TODAY(), "Overdue", "")
0
 
LiamMcKayAuthor Commented:
When doing this, the Overdue text still displays when the other feilds are blank.  
0
 
Rory ArchibaldCommented:
Try:
=IF(AND(COUNTA(B3:B4)=2,OR(B3<TODAY(),B4<TODAY())),"Overdue", "")
0
 
jppintoCommented:
Change to this:

=IF(AND(B3<TODAY(),B3<>""), "Overdue", "")

0
 
jppintoCommented:
Sample file attached.

jppinto
sample-1-.xlsx
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now