I have a spreadsheet similar to this. I need to count the number of dates in
column A that are less than C1. If the date in column A is greater than C1
than I want to count the date in column B if it is less than C1. If the date
in column A & B are both less than C1 they should count as 1 and not 2. In
the example below 9 dates meet the criteria (8 in column A and 1 in column
B). Also the database length will vary and will contain blank cells after
the last entry in column A.

A B C
1/2/2009 3/2/2008 9/16/2009
3/2/2009 6/5/2008
6/5/2008 9/4/2008
3/1/2010
1/1/2010 4/1/2009
7/5/2009
9/15/2008 9/15/2009
12/4/2008
11/4/2008



2/12/2009
3/12/2010


--
Robert K