Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
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 =) |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Today() or Date() function help | Excel Discussion (Misc queries) | |||
Could anyone help me with (Today function), please? | New Users to Excel | |||
Can I use TODAY Function in formula without it changing the next . | Excel Discussion (Misc queries) | |||
Can I use TODAY Function in a formula that will not change it the. | Excel Discussion (Misc queries) | |||
Formula to list unique values | Excel Worksheet Functions |