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 =) |
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. |
All times are GMT +1. The time now is 07:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com