Function Dates Times Class

FirstDayOfWeekInMonth

Returns the first day of the week (for example, the first Tuesday) in the specified month.

Signature (Visual Basic / VBA)

Public Function FirstDayOfWeekInMonth( _
      ByVal vYear As Variant _
    , ByVal vMonth As Variant _
    , ByVal vDayOfWeek As Variant _
    ) As Variant

Code Example

    Weekday(#1/1/96#) = vbMonday
    FirstDayOfWeekInMonth(1996, 1, vbMonday) = #1/1/96#
    FirstDayOfWeekInMonth(1996, 1, vbFriday) = #1/5/96#
    FirstDayOfWeekInMonth(1996, 1, vbSunday) = #1/7/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. Function returns Null if vMonth is Null or cannot be interpreted as an integer number.
vDayOfWeek One of the vbDayOfWeek constants like vbSunday, vbMonday, etc. Function returns Null if vDayOfWeek 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.