Function Dates Times Class

EndOfMonth

Returns the last day in the month given a date value.

Signature (Visual Basic / VBA)

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

Code Example

    EndOfMonth(#01/15/96#) = #01/31/96#
    EndOfMonth(#12/01/96#) = #12/31/96#
    EndOfMonth(#12/31/96#) = #12/31/96#
    EndOfMonth(#02/01/96#) = #02/29/96#

Parameters

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

Notes & Version History

Note This function DOES support pre-1900 Date/time values.