Function Dates Times Class

DaysInMonth

Return the number of the last day of the month for a given date. Same as returning the last day of the month.

Signature (Visual Basic / VBA)

Public Function DaysInMonth( _
    ByVal vDate As Variant _
    ) As Variant

Code Example

    DaysInMonth(#1/15/2000#) = 31
    DaysInMonth(#2/15/2000#) = 29
    DaysInMonth(#2/15/2001#) = 28
    DaysInMonth(#3/21/2001#) = 31

Parameters

Parameter Description
vDate The date whose month is examined to determine the last day of the month. Function returns Null if vDate is Null or cannot be fixed up to a Date.