Help with date

[boltman]

Hello All

How do I get excel to place the current date in cell k2 when the data
in cell L2 is added or changed? This formula stuff is almost beyond
me!!!!!!!

Thanks Keith

 

[Peo Sjoblom]

See:

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

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

 

[Alex Rohan]

In k2, typ

=today(

today() displays the current date no matter what other cells are added or changed. That should do the trick!

 

[Peo Sjoblom]

Not if the purpose is to datestamp every time
this particular cell is changed, a formula
like TODAY will change every time any cell is calculated or
every time the workbook is opened. So if the OP changed
a cell today and want to keep that date until the cell is changed again,
but if he opens the file tomorrow that date will change to 05/25/04

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

In k2, type

=today()

today() displays the current date no matter what other cells are added or

changed. That should do the trick!

 

[boltman]

I tried using the steps on McGimpsey's webpage using the circular
reference and making the change to the tools/options/calculations and
the date cell displays "0". I am probably overlooking something
simple.

Keith

 

[Alex Rohan]

Misinterpreted the question, sorry!

 

[Frank Kabel]

Hi
I would suggest you use the worksheet_change event procedure outlines
on this site