There really isn't a worksheet formula to do that. Typically the date is
entered into a cell via = NOW() or another date function, but it will change
as time goes by. Now is Now, not Then. So, as Don Guilett has implied, it
is going to take some VBA code behind the scenes that detects when you make a
change in the cell(s) you are interested in tracking and then places the time
stamp of the (last?) change in a cell somewhere in a more permanent fashion.

If you need more help with this, just yell.

"JohnNuTek" wrote:

I am trying to figure out a formulla to make the date appear in one cell
everytime anouther cell's data is chaged.