On May 16, 10:48*am, "T. Valko" wrote:
See this:
http://www.mcgimpsey.com/excel/timestamp.html
--
Biff
Microsoft Excel MVP
"GMc" wrote in message
...
Is there any way (other that cut/paste value & using a macro) to enter
adateinto a cell based on the outcome of another cell, and fix the
dateso that it does not change during time.
The following formula will enter thedate, however if I open the
workbook up 3 days later it will always change thedateto today's.
=if(B6="Yes",today(),"")
Any ideas on how to keep thedatefixed for when cell "B6" changed to
"Yes" ?
Thanks
GMc.- Hide quoted text -
- Show quoted text -
Thanks very much for the information, I tried it out and it works
great, thanks. GMc.