Posted to microsoft.public.excel.worksheet.functions
|
|
Date Question
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
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.
|