Date Question

[GMc]

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.

 

[T. Valko]

See this:

http://www.mcgimpsey.com/excel/timestamp.html

 

[GMc]

See this:

http://www.mcgimpsey.com/excel/timestamp.html

--
Biff
Microsoft Excel MVP







- Show quoted text -

Thanks very much for the information, I tried it out and it works
great, thanks. GMc.

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP

See this:

http://www.mcgimpsey.com/excel/timestamp.html

--
Biff
Microsoft Excel MVP







- Show quoted text -

Thanks very much for the information, I tried it out and it works
great, thanks. GMc.