Thanks Dav,
Can i have a macro to fix the date

TIA

"Dave" wrote:

Hi, try this.
In cell B1 of sheet 2, insert the following, then fill down:
=IF(COUNTIF(Sheet1!$A$1:$A$5,A1)0,"Yes","na")
In cell C1 of sheet 2, insert the following, then fill down:
=IF(B1="Yes",TODAY(),"")

If you want the date to be fixed, and not always show the current date, you
would need to use an event macro, or a macro one you run manually.
Regards - Dave.