Thread: TODAY Function
View Single Post
  #1   Report Post  
Chip1035
 
Posts: n/a
Default TODAY Function

I have a worksheet with data on it with the date the data was entered. Is
there a formula that change the date when data is entered or changed? The
date is to stay the same while the document is being viewed, not edited.

Example
A1 is Color
A2 is Red
B1 is Updated
B2 is 12/14/2004
If I changed A2 from Red to Blue or add A3 is Blue, the date in B2 changes
to the date I changed/added data.
--
-Chip
=)