Solved

# Overdue Dates Formula in Excel

Posted on 2011-05-12
1,261 Views
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
Question by:LiamMcKay

LVL 33

Expert Comment

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

To this:

=IF(B3<TODAY(), "Overdue", "")
0

Author Comment

When doing this, the Overdue text still displays when the other feilds are blank.
0

LVL 85

Expert Comment

Try:
=IF(AND(COUNTA(B3:B4)=2,OR(B3<TODAY(),B4<TODAY())),"Overdue", "")
0

LVL 33

Expert Comment

Change to this:

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

0

LVL 33

Accepted Solution

Sample file attached.

jppinto
sample-1-.xlsx
0

## Featured Post

Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.