Formula

Is there a way to post a date and time in a cell or column along with a fomula, that will update to the current date and time everytime you adjust/change something in that cell?

Can't be done with a formula or it will update whenever calculation takes
place not just when that cell is updated.

See John McGimpsey's site for code to set a time stamp whenever a cell is
updated.

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


Gord Dibben Excel MVP

On Thu, 6 Oct 2005 13:18:13 -0500, deaculver
<[email protected]> wrote:

>
>Is there a way to post a date and time in a cell or column along with a
>fomula, that will update to the current date and time everytime you
>adjust/change something in that cell?

Maybe...

You may want to look at how JE McGimpsey does it (just for comparison):
http://www.mcgimpsey.com/excel/timestamp.html

deaculver wrote:
>
> Is there a way to post a date and time in a cell or column along with a
> fomula, that will update to the current date and time everytime you
> adjust/change something in that cell?
>
> --
> deaculver
> ------------------------------------------------------------------------
> deaculver's Profile: http://www.excelforum.com/member.php...o&userid=27882
> View this thread: http://www.excelforum.com/showthread...hreadid=473866

--

Dave Peterson