Thank you. I used a version of what you provided and it works perfectly. I
appreciate your help.

Sue

"Aladin Akyurek" wrote:

Something like...

=SUMPRODUCT(--(CommittedCureDates <
TODAY()),--(ActualCureDates=DefaultDate))

where DefaultDate is a cell housing a true date.

Sue wrote:
I have a spreadsheet that has 4 columns in my results page. These columns
contain dates. For instance I have a Committed Cure date and an Actual Cure
date and then a committed test date and an actual test date.

There are a number of rows and several sections that need to be counted
separately. How do I write an IF statement to show if the committed cure
date is in the past and the actual cure date is showing a default date (until
real date is populated) of 0-Jan-00 how many lines meet this criteria?

I would have to do the same type of statement for my testing dates.

If it's easier to do a countif function what would be the best way to write
that function?

Thank you in advance.