how do i set up a formula to enter the date in a cell when the value of
another cell is modified? i used an if argument with the NOW function,
however any time it is updated or changed all the previous dates change with
it. any help would be appreciated. thanx.

mgawbamo, have a look here for a way to do it,
http://www.mcgimpsey.com/excel/timestamp.html
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"mgawbamo" wrote in message
...
how do i set up a formula to enter the date in a cell when the value of
another cell is modified? i used an if argument with the NOW function,
however any time it is updated or changed all the previous dates change
with
it. any help would be appreciated. thanx.

THANX! big help!

"Paul B" wrote:

mgawbamo, have a look here for a way to do it,
http://www.mcgimpsey.com/excel/timestamp.html
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"mgawbamo" wrote in message
...
how do i set up a formula to enter the date in a cell when the value of
another cell is modified? i used an if argument with the NOW function,
however any time it is updated or changed all the previous dates change
with
it. any help would be appreciated. thanx.