Capturing Date

[Larry Fish via OfficeKB.com]

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.

 

[Guest]

Hi,

Why do you need a macro for this if Excel has a formula like this? In Cell
D2, put: =TODAY()

 

[Alan]

Sub Macro1()
Sheet1.Range("D2") = Date
End Sub
Regards,
Alan.

 

[SteveW]

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

Steve

 

[MartinW]

The TODAY() and NOW() functions are volatile and will constantly
update. If you want the date to stick just hit ctrl+; for the date only.
If you want date and time hit ctrl+; space ctrl+shift+:

If you need it automatic then have a look here

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

HTH
Martin