<div>
Are you sure that DateAdd is existing as a formula in Excel. I don't see it!<br />
<br />
You can do simply : =D11+B11<br />

</div>


Are you sure that DateAdd is existing as a formula in Excel. I don't see it!

You can do simply : =D11+B11


<div>
Good pickup TimCottee - my silly error not picking it up that I was not returning a date - dont you hate days like that - I spent nearly an hour checking and double checking what I was doing ... I think I need some sleep .. lol<br />
<br />
DarrinE
</div>


Good pickup TimCottee - my silly error not picking it up that I was not returning a date - dont you hate days like that - I spent nearly an hour checking and double checking what I was doing ... I think I need some sleep .. lol

DarrinE

<div>
<div class="content wysiwyg-content">
In excel I would like to use the DateAdd function to add a number of days to a date which are contained in cells using the following function<br />
<br />
Function DatesAdd(iinterval As String, nnumber As Integer, ddate As Date) As Integer<br />
<br />
&nbsp; &nbsp; DatesAdd = DateAdd(iinterval, nnumber, ddate)<br />
<br />
End Function<br />
<br />
<br />
In the formula bar - how would I call this function ?<br />
<br />
I have tried <br />
<br />
=DatesAdd(&quot;d&quot;,D11,B11)<br />
<br />
but get the #Value! error<br />
<br />
DarrinE<br />
<br />

</div>
</div>


In excel I would like to use the DateAdd function to add a number of days to a date which are contained in cells using the following function

Function DatesAdd(iinterval As String, nnumber As Integer, ddate As Date) As Integer

    DatesAdd = DateAdd(iinterval, nnumber, ddate)

End Function


In the formula bar - how would I call this function ?

I have tried 

=DatesAdd("d",D11,B11)

but get the #Value! error

DarrinE



Excel and DateAdd

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.