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.

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.

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.

You're welcome!

--
Biff
Microsoft Excel MVP


"GMc" wrote in message
...
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.