Compare columns

[rhino335]

Hi

I have two columns of dates in say columnA & columnB totalling 320 rows. I need to compare the two columns row by row and count the total number of times the date in columnB is more recent than columnA

Can anyone help me?

Thanks

[Steve0492]

Hello rhino, welcome to the forum!

How are we able to tell which data is more recent? Is your data simply dates? A little more info or even attaching your spreadsheet will help others help you.

Steve

[ChemistB]

Try

=SUMPRODUCT(--($B$2:$B$300>$A$2:$A$300))
Does that work for you?

[rhino335]

Steve

Thanks for the prompt response. However, before I could get the info to you ChemistB answered the problem.