Function Dates Times Class

DayNumber

Return the number of days since 1/1/1 plus one.

Signature (Visual Basic / VBA)

Public Function DayNumber( _
      ByVal vYear As Variant _
    , ByVal vMonth As Variant _
    , ByVal vDay As Variant _
    ) As Variant

Code Example

    DayNumber(1999, 11, 12) = 730072
    DayNumber(1903, 12, 17) = 695043
    DayNumber(1776, 7, 4) = 648493
    DayNumber(1, 1, 1) = 1

Parameters

Parameter Description
vYear Must use the full four-digit year; cannot use 96, for example, to mean 1996. Function returns Null if vYear is Null or cannot be interpreted as an integer number.
vMonth Month in the year vYear. Function returns Null if vMonth is Null or cannot be interpreted as an integer number.
vDay Day in the month vMonth. Function returns Null if vDayis Null or cannot be interpreted as an integer number.

Notes & Version History

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