Is there any way (other that cut/paste value & using a macro) to enter
a date into a cell based on the outcome of another cell, and fix the
date so that it does not change during time.

The following formula will enter the date, however if I open the
workbook up 3 days later it will always change the date to today's.

=if(B6="Yes",today(),"")

Any ideas on how to keep the date fixed for when cell "B6" changed to
"Yes" ?

Thanks

GMc.