Hi,
Try this
=SUMPRODUCT(1*(G26:G28<H26:H28))
Hope it helps.
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"RobertK" wrote in message
...
I have a spreadsheet with 2 columns of dates (approximately 1200 rows) and
want the count in column A where the date is less than column B.
A B
1/2/09 1/8/09
4/5/08 5/6/07
5/6/09 9/5/08
In the above example the answer I'm looking for is 1.
--
Robert K