Hi Ratheesh,

You don't really need any code for this, a simple formula will work as I
understand your question. Try this: =IF(A1=TODAY(),A1,"")

Enter this into cell B1 and copy it down the rows that you need it. It will
display the date in the same row of Column B as the date in Column A that
matches the current date, and an empty looking cell when the date in A does
not match the current date.

HTH
Bill

"Ratheesh" wrote:

Hi All -

Could you please help me on this?

In a worksheet "A" column containing birthdays(date, dd/mm/yyyy). How
can I write a code to show date & month("A" column) matching with
todays date & month in the respective "B" column.?

Thanks a lot in advance for your helps...
Ratheesh
.