Function Math Financial Class

Days360

Determine the number of days between two dates using the specified day count basis (either US_NASD_30_360 or European_30_360 ).

Signature (Visual Basic / VBA)

Public Function Days360( _
      ByVal vFm As Variant _
    , ByVal vTo As Variant _
    , Optional ByVal vEuroMethod As Variant _
    , Optional ByVal vExcelVersion As Variant _
    ) As Variant

Code Examples

    Days360(#1/1/96, #2/15/96#) = 44
    Days360(#1/1/96, #2/15/96#, True) = 44
    Days360(#1/1/96, #3/15/96#) = 74
    Days360(#1/1/96, #3/15/96#) = 74
    Days360(#2/28/96, #5/31/96#) = 93
    Days360(#2/28/96, #5/31/96#, True) = 92
                              vEuro vExcelVersion
        vFm          vTo      Method False   True
    #02/28/1991# #02/28/1991# False      0     -2
    #02/28/1991# #02/29/1992# False    360    359
    #02/28/1991# #02/28/1993# False    720    718
    #02/28/1991# #02/28/1994# False  1,080  1,078
    #02/28/1991# #02/28/1995# False  1,440  1,438
    #02/28/1991# #02/29/1996# False  1,800  1,799
    #02/28/1991# #02/28/1997# False  2,160  2,158
    #02/29/1992# #02/28/1991# False   -360   -362
    #02/29/1992# #02/29/1992# False      0     -1
    #02/29/1992# #02/28/1993# False    360    358
    #02/29/1992# #02/28/1994# False    720    718
    #02/29/1992# #02/28/1995# False  1,080  1,078
    #02/29/1992# #02/29/1996# False  1,440  1,439
    #02/29/1992# #02/28/1997# False  1,800  1,798
    #02/28/1993# #02/28/1991# False   -720   -722
    #02/28/1993# #02/29/1992# False   -360   -361
    #02/28/1993# #02/28/1993# False      0     -2
    #02/28/1993# #02/28/1994# False    360    358
    #02/28/1993# #02/28/1995# False    720    718
    #02/28/1993# #02/29/1996# False  1,080  1,079
    #02/28/1993# #02/28/1997# False  1,440  1,438
    #02/28/1994# #02/28/1991# False -1,080 -1,082
    #02/28/1994# #02/29/1992# False   -720   -721
    #02/28/1994# #02/28/1993# False   -360   -362
    #02/28/1994# #02/28/1994# False      0     -2
    #02/28/1994# #02/28/1995# False    360    358
    #02/28/1994# #02/29/1996# False    720    719
    #02/28/1994# #02/28/1997# False  1,080  1,078
    #02/28/1995# #02/28/1991# False -1,440 -1,442
    #02/28/1995# #02/29/1992# False -1,080 -1,081
    #02/28/1995# #02/28/1993# False   -720   -722
    #02/28/1995# #02/28/1994# False   -360   -362
    #02/28/1995# #02/28/1995# False      0     -2
    #02/28/1995# #02/29/1996# False    360    359
    #02/28/1995# #02/28/1997# False    720    718
    #02/29/1996# #02/28/1991# False -1,800 -1,802
    #02/29/1996# #02/29/1992# False -1,440 -1,441
    #02/29/1996# #02/28/1993# False -1,080 -1,082
    #02/29/1996# #02/28/1994# False   -720   -722
    #02/29/1996# #02/28/1995# False   -360   -362
    #02/29/1996# #02/29/1996# False      0     -1
    #02/29/1996# #02/28/1997# False    360    358
    #02/28/1997# #02/28/1991# False -2,160 -2,162
    #02/28/1997# #02/29/1992# False -1,800 -1,801
    #02/28/1997# #02/28/1993# False -1,440 -1,442
    #02/28/1997# #02/28/1994# False -1,080 -1,082
    #02/28/1997# #02/28/1995# False   -720   -722
    #02/28/1997# #02/29/1996# False   -360   -361
    #02/28/1997# #02/28/1997# False      0     -2

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.
vEuroMethod Optional True or False value. True if the European 30/360 day count basis should be used, and False if the US NASD 30/360 day count basis should be used. vEuroMethod defaults to False (use the US NASD 30/360 day count basis) if it is missing or Null or cannot be interpreted as a Boolean value.
vExcelVersion Optional True or False value. True if the function should return the exact same results as the Microsoft Excel DAYS360 function, 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) if it is missing or Null or cannot be interpreted as a Boolean value.

Notes & Version History

Details See the Days360Verify Subroutine for more examples of this Function.
Note This function returns the exact same results as the Microsoft Excel DAYS360 function when the vExcelVersion argument is True. When the vExcelVersion argument is False, this function and the Excel Days360 function differ on the following dates: (This is the output of the Days360ExcelTest Subroutine.)
v2.0 Addition This function is new to this version of Entisoft Tools.