One way


=SUMPRODUCT(--(A2:A20<DATE(2009,9,30)),--(E2:E20<TODAY()))


you can replace DATE(2009,9,30) which is hard coded (in this case eom sep09)
with a cell where you put the date in question

--


Regards,


Peo Sjoblom


"RobertK" wrote in message
...
I have a spreadsheet with several columns, two of which are dates (say
columns A & E). I want to count the numer of times column A is less than
a
certain date (usually the end of a month) plus the number of times column
E
is less than today. However, if column A and E are both less than today I
only want to count it once.
--
Robert K