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.

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.

Take the oppotunity to learn about PIVOTtables. it looks totally vierd
in the start but it realy is the tool for this type of operations


--
nijunge
------------------------------------------------------------------------
nijunge's Profile: http://www.excelforum.com/member.php...o&userid=26404
View this thread: http://www.excelforum.com/showthread...hreadid=398843

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.