It doesn't. Date is the VBA equipvalent of the worksheet function =today().
I was suggesting that there was no reason to store a date in A1 if the only
purpose was to use it as a reference for advancing 30 days.

--
Regards,
Tom Ogilvy

Nathan Gutman wrote in message
...
Hi Tom,
In the second example how does the code know that Date is the value of
Today() from A1?
On Wed, 10 Dec 2003 12:32:57 -0500, "Tom Ogilvy"
wrote:

With Range("B1")
.Value = Date + 30
.Numberformat = "mm/dd/yyyy"
End With