=today() puts the current date as taken from your PC !
=now() is the same plus the time

Steve

On Tue, 26 Sep 2006 13:39:45 +0100, Larry Fish via OfficeKB.com
<u27092@uwe wrote:

I have tried writing a macro that would let me capture the date from my
computer and place it in cell D2. The captured day will be moved intact
at
the end of the day

Is there a command that will let me do that?

Thanks for the help in advance.