View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rick[_19_] Rick[_19_] is offline
external usenet poster
 
Posts: 52
Default Application.WorkSheetFunction.DafeDif (not DateDiff)

Am I doing this wrong? Or, can I not call DateDif from vb? I don't want to use datediff because it doesn't give real time. Ie: the months start on the first, not on the day of month chosen. Is there a better way w/o having to open a worksheet to get the data

Sub AccFreeTime(
Dim AccDayTime As Dat
Dim Result As Varian
Result = Application.WorksheetFunction.DateDif(AccDayTime, NOW(), "ym"
MsgBox (Result
End Su

Thanks in advance for any/all assistance.