How do I keep the date from being updated every day
 

I use the following formula in an Excel worksheet:
=IF(L2=0,"",TODAY())

I would like for it to stay the original date it puts in there. Right now I
have to copy the entries and paste them back as values so it won't change the
date tomorrow when I start the spreadsheet again.

Take a look at

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


In article ,
JDP wrote:

I use the following formula in an Excel worksheet:
=IF(L2=0,"",TODAY())

I would like for it to stay the original date it puts in there. Right now I
have to copy the entries and paste them back as values so it won't change the
date tomorrow when I start the spreadsheet again.

I created a simple macro to do this that enters the today() function into the
desired cell then copies and pastes the values of that cell over itself.
Thus pressing the shortcut key (ctrl+shift+d in my case) will enter the date
of today into the desired cell as text which will not change unless you run
the macro again. This is a very simple macro to create using the macro
recorder. If you are new to macros I could walk you through it.



"JDP" wrote:

I use the following formula in an Excel worksheet:
=IF(L2=0,"",TODAY())

I would like for it to stay the original date it puts in there. Right now I
have to copy the entries and paste them back as values so it won't change the
date tomorrow when I start the spreadsheet again.

Brandt

CRTL + ; will also enter a static today's date in a cell, but this doesn't
help JDP with the TODAY() function in a formula.

Gord Dibben Excel MVP

On Thu, 23 Dec 2004 11:37:02 -0800, Brandt
wrote:

I created a simple macro to do this that enters the today() function into the
desired cell then copies and pastes the values of that cell over itself.
Thus pressing the shortcut key (ctrl+shift+d in my case) will enter the date
of today into the desired cell as text which will not change unless you run
the macro again. This is a very simple macro to create using the macro
recorder. If you are new to macros I could walk you through it.



"JDP" wrote:

I use the following formula in an Excel worksheet:
=IF(L2=0,"",TODAY())

I would like for it to stay the original date it puts in there. Right now I
have to copy the entries and paste them back as values so it won't change the
date tomorrow when I start the spreadsheet again.