Thank you, that did the trick.
--
Robert K


"Jacob Skaria" wrote:

Hi Robert

You can try the below formula. Please note that this is an array formula. An
array formula can perform multiple calculations and then return either a
single result or multiple results. Array formulas act on two or more sets of
values known as array arguments. Each array argument must have the same
number of rows and columns. You create array formulas in the same way that
you create other formulas, except you press CTRL+SHIFT+ENTER to enter the
formula. If successful in 'Formula Bar' you can notice the curly braces at
both ends like "{=<formula}"

=SUM((IF(A1:A1000,IF(A1:A100<C1,1,IF(B1:B1000,IF (B1:B100<C1,1,0))))))

If this post helps click Yes
---------------
Jacob Skaria


"RobertK" wrote:

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