Counting latest date in two columns
That would hardly remove all doubts in cases where the day is less than 13?
The only way would be to use either
2009-12-25.
--
Regards,
Peo Sjoblom
"Mike H" wrote in message
...
Hi,
Because of the sample dates you provided this is very difficult to answer
1/2/2009 is this 1 Feb or 2 Jan?
When posting dates use examples that remove all doubt
e.g 25/12/2009
If I've guessed correctly try this
=SUMPRODUCT(--(A1:A20<B1:B20))
Mike
"RobertK" wrote:
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
|