View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RobertK RobertK is offline
external usenet poster
 
Posts: 28
Default Counting latest date in two columns

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