IrishCharm
03-05-2009, 05:08 AM
Hi,
I want to use the Days360 function within VB but am unsure how it works - the below was the closest i came to getting it work.
Any ideas??
Option Explicit
Sub TEST()
Dim str_Date1 As Date
Dim str_Date2 As Date
str_Date1 = "28/03/2008"
str_Date2 = "25/07/2009"
MsgBox Application.WorksheetFunction.Days360(Range(str_Date1), Range(str_Date2))
End Sub
I want to use the Days360 function within VB but am unsure how it works - the below was the closest i came to getting it work.
Any ideas??
Option Explicit
Sub TEST()
Dim str_Date1 As Date
Dim str_Date2 As Date
str_Date1 = "28/03/2008"
str_Date2 = "25/07/2009"
MsgBox Application.WorksheetFunction.Days360(Range(str_Date1), Range(str_Date2))
End Sub