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.
Bookmarks