Function Dates Times Class

LastWeekdayOfMonth

Returns the last weekday of the month, with the weekdays considered Monday through Friday. Same as LastBusinessDayOfMonth , but accepts arguments differently.

Signature (Visual Basic / VBA)

Public Function LastWeekdayOfMonth( _
      ByVal vYear As Variant _
    , ByVal vMonth As Variant _
    ) As Variant

Code Example

    LastWeekdayOfMonth(1996, 1) = #1/31/96#
    LastWeekdayOfMonth(1996, 2) = #2/29/96#
    LastWeekdayOfMonth(1996, 3) = #3/29/96#
    LastWeekdayOfMonth(1996, 4) = #4/30/96#

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 whose last weekday is returned. Function returns Null if vMonth is 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.