DateAdd

[Michael Wise]

Is there any way for format the DateAdd function

Here is what I have which of course does not work

da = DateAdd("d", 30, (Format(Date, "dd-mmm-yy"))

 

[Chip Pearson]

Why do you want to use Format within DateAdd in the first place?
Just use

da = DateAdd("d",30,Now)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Michael Wise >" <<[email protected]>
wrote in message
news:[email protected]...