Range("a1").value = now()

will work

"RyanH" wrote:

I have a command button on a worksheet that moves certain dates forward by
one week. The user should only click this button at the beginning of every
work week. Is there a way to show the date in a cell next to the command
button when the command button was clicked?

Thanks for your help in advance!
Ryan