Date Stamp in Excell

[Gootz11]

Hello, I need one of my cells to put a date stamp on that row every time a value is entered. Example every time a value is entered in cell D14, Cell AF14 will automatically put today’s date and keep that date forever. I tried the following formula =IF (D14,TODAy(),"") but every time I open my spreadsheet it changes to the current date. Please Help.
Thanks in advance
JG

 

[AnotherHiggins]

This can't be done without code since, as you noted, the TODAY and NOW formulas are dynamic. Have a look at faq707-1657.

[tt]_____
[blue]-John[/blue]
[/tt][red]"I'm against picketing, but I don't know how to show it."[/red]
-Mitch Hedberg

Help us help you. Please read FAQ181-2886 before posting.

 

[sawedoff]

You can enter =TODAY() or NOW(), then instead of hitting enter, press F9 then enter. It will put today's date in, but as a constant instead of a dynamic.

Sawedoff