Function Math Financial Class

DaysBetweenDates

Determine the number of days between two dates using the specified day count basis. Version of the Days360 function that supports all of the Day Count Basis constants.

Signature (Visual Basic / VBA)

Public Function DaysBetweenDates( _
      ByVal vFm As Variant _
    , ByVal vTo As Variant _
    , Optional ByVal vBasis As Variant _
    , Optional ByVal vExcelVersion As Variant _
    ) As Variant

Code Example

    DaysBetweenDates(#1/1/96, #2/15/96#, US_NASD_30_360) = 44
    DaysBetweenDates(#1/1/96, #2/15/96#, European_30_360) = 44
    DaysBetweenDates(#1/1/96, #3/15/96#) = 74
    DaysBetweenDates(#1/1/96, #3/15/96#) = 74
    DaysBetweenDates(#2/28/96, #5/31/96#) = 93
    DaysBetweenDates(#2/28/96, #5/31/96#, Eutopean_30_360) = 92

Parameters

Parameter Description
vFm The beginning (first day) of the date interval. Function returns Null if vFm is Null or cannot be interpreted as a Date. The time component of vFm (if any) is ignored.
vTo The end (last day) of the date interval. Function returns Null if vTo is Null or cannot be interpreted as a Date. The time component of vTo (if any) is ignored.
vBasis Optional day count basis that determines how to count the difference in days and years. One of the following day count basis constants: US_NASD_30_360 , Actual_Actual , Actual_360 , Actual_365 , or European_30_360 . vBasis defaults to US_NASD_30_360 if it is missing or Null or cannot be interpreted as a number. Function returns Null if vBasis is not one of the recognized Day Count Basis constants.
vExcelVersion Optional True or False value. This value only affects this function when vBasis is US_NASD_30_360 . True if the function should return the exact same results as the Microsoft Excel DAYS360 function when vBasis is US_NASD_30_360 , and False if it should use the Securities Industy Association definition of the 30/360 day count basis. vExcelVersion defaults to False (use the SIA definition for the US NASD 30/360 day count basis when vBasis is US_NASD_30_360 ) if it is missing or Null or cannot be interpreted as a Boolean value. See the Days360 function for details on how the vExcelVersion argument affects the result of this function.

Notes & Version History

v2.0 Addition This function is new to this version of Entisoft Tools.