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 "
wrote in message
...
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")))


---
Message posted from http://www.ExcelForum.com/