Matching Partial data in columns

HI,

I have two below columns in my spread sheet i.e column A and B. Now I would like to have the result "today" in column C if coulmun A date matches with column B.

------COLUMN A;-COLUMN B ;----COLUMNC
10/9/2007 20:42 ; 10/9/2007 ; TODAY
9/26/2007 19:55 ; 10/9/2007 ;
9/26/2007 19:05 ; 10/9/2007 ;
10/9/2007 20:42 ; 10/9/2007 ;
9/26/2007 20:10 ; 10/9/2007 ;
9/26/2007 22:20 ; 10/9/2007 ;
10/9/2007 20:42 ; 10/9/2007 ;TODAY
9/23/2007 18:52 ; 10/9/2007 ;

Could anyone give some function or macro for this.
your help appreciated.

Maybe

=IF(TEXT(A1,"mm/dd/yy")=TEXT(B1,"mm/dd/yy")=TRUE,B1,"")

or

=IF(LEFT(A1,5)=LEFT(B1,5)=TRUE,B1,"")

VBA Noob