edate function in VBA

[fdiez67]

Is it possible to use edate function in VBA? I tried
WorksheetFunction.edate = ... and that doesn't work. TIA.

 

[merjet]

Is it possible to use edate function in VBA? I tried

WorksheetFunction.edate = ... and that doesn't work. TIA.

That particular worksheet function is not accessible in
VBA. You can find out which ones are accessible by
using the Object Browser.

Merjet

 

[Bob Phillips]

Try something like

MsgBox Format(Application.Evaluate("edate(A16, 5)"), "dd mmm yyyy")


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Chip Pearson]

The EDate function is part of the Analysis Tool Pak add-in. To use it in
VBA, you need to first load the "Analysis Tool Pak - VBA" add-in in Excel.
Then, open your VBA project, go to the Tools menu, choose Reference, and put
a check next to ATBVBAEN.xls item. Once you do this, you can access the
function directly. E.g.,

Dim Res
Res = edate(Now, 3)
Debug.Print Res


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