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
=)

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

--
Regards
Frank Kabel
Frankfurt, Germany

Chip1035 wrote:
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.