How to compare dates

I have dates in col A and Col B. I want to match the col A dates with Col B and want to have the dates which matches.

for eg
A B C
15/2/2009 15/2/2009 Y
25/2/2009 26/2/2009 N
5/2/2009 26/2/2009 N

Please reply & thanks in advance.

Hi

in column C1 use formula =IF(A1=B1,"Y","N") to return a Y value for matches and an N value for non-matches, drag formula down as far as cells A & B are populated

I think should better post the ques as...

I need to match A1 with the entire B column and not only with the adjacent value.

Please help me resolving this.

Thanks for answering.

ok you will need a vlookup then eg =VLOOKUP(A:A,B:B,1,FALSE) where cell C will return an #N/A where it doesn't recognise the date in column A anywhere in column B and a date value where it recognises across both columns. you can then change all #N/A values to "N" and all else to "Y"

there's probably way fancier ways our there though- that's my quick solution, hope it helps