Help with date

  • Thread starter Thread starter boltman
  • Start date Start date
B

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
 
In k2, typ

=today(

today() displays the current date no matter what other cells are added or changed. That should do the trick!
 
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

Alex Rohan said:
In k2, type

=today()

today() displays the current date no matter what other cells are added or
Click to expand...
changed. That should do the trick!
 
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
 
Hi
I would suggest you use the worksheet_change event procedure outlines
on this site
 
Back
Top