App.Datevalue function not in VBA

  • Thread starter Thread starter Office Engineer
  • Start date Start date
O

Office Engineer

Hi
I have tried ;
Application.Worksheetfunction.Datevalue(...)
but it seems Datevalue isn't available (other worksheet functions are).
I suspect this may be a missing reference in the VBA.
Any suggestions?
 
The DateValue function exists as a native VBA function. It converts a text
representation of a date into an Excel date (a serial number). For example:

MsgBox DateValue("12/2/2009") - 30

returns 11/2/2009 (the date value of 12/2/2009 minus 30 days).

Hope this helps,

Hutch
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

index function in vba 3
Excel VBA 1
CommonButton was out of function since Dec 2014 6
VBA Function Not Recognized or Execution Issue 7
VBA Countif across sheets? 5
Accessing the Bessel Function within VBA in Excel 2007 6
vba macro that allows insertion of symbols at cursor 0
How to assign a worksheet in VBA 3

Back
Top