Application Datevalue Function not Vba

March 7, 2009 by vba excel
Filed under: Excel Date Functions 
Sponsor

Excel Date Functions Question:

I confuse due to a excel application datevalue function which is not vba, i have tried :
Application.Worksheetfunction.Datevalue(…)
but it seems Datevalue isn’t available or supported (other worksheet functions are). I guess this may be a missing reference in the VBA. Any suggestions?

Excel Date Functions Answer:

The DateValue is a excel function which exists as a native VBA function. It converts a text representation of a date into a microsoft 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).

  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Google
  • E-mail this story to a friend!
  • Live
  • MisterWong
  • Propeller
  • StumbleUpon
  • Technorati
  • TwitThis
  • YahooMyWeb
  • Print this article!

Rate This Tips:

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading ... Loading ...


Incoming excel search terms

excel vba datevalue,vba datevalue,datevalue vba,excel datevalue function,vba excel datevalue,datevalue vba excel,worksheetfunction datevalue,datevalue in vba,vba datevalue function,datevalue excel,excel application date,excel vba datevalue function,application worksheetfunction datevalue,datevalue function in excel,datevalue function vba,excel application ondate,vba application date,,application datevalue,call excel workbook function datevalue from vba,datevalue excel macro,datevalue excel vba,datevalue excel vba add 6 months,datevalue in worksheet in vba,datevalue vb excel,excel datevalue,excel datevalue example,f,find datevalue vba,how extract datevalue from string using vba,less than or equal datevalue(now) in excel vba,mss,use excel datevalue function in vba,vb datevalue,vba datevalue excel,vba datevalue(),vba excel date from other worksheet,:countif datevalue example,0 as datevalue in excel vba,0h,application date() in vba,application datevalue vba excel,application ondate datevalue,application today excel vba,application worksheetfunction giving a date day number,application worksheetfunction today,create date from datevalue vba,current datevalue in vba,date function excel application,date function not working in macro



Related Excel Tips

Tags: , , , , , , , ,

Comments

2 Comments on Application Datevalue Function not Vba

  1. Samran Pasha on Wed, 25th Nov 2009 11:07 am

    2. Is there any function in excel to get a stable date, EX if i use NOW() and TODAY() it will give the system date, however it will change for the next day.

  2. Mins on Mon, 29th Mar 2010 3:37 pm

    3. Samran, I don’t know about function but this neat trick will insert the today’s date:-
    [CTRL]+[;]

    That’s CTRL and the semi-colon keys

Have another excel answer or questions for this problem ?
Feel free to post it here..