Function Dates Times Class

FirstBusinessDayOfMonth

Returns the first weekday in the month given a date value. Same as FirstWeekdayOfMonth , but accepts arguments differently.

Signature (Visual Basic / VBA)

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

Code Example

    FirstDayOfMonth(#9/15/1996#) = #9/1/1996#
    Format$(#9/1/1996#, "ddd") = "Sun"
    FirstBusinessDayOfMonth(#9/15/1996#) = #9/2/1996#
    Format$(#9/2/1996#, "ddd") = "Mon"
    FirstDayOfMonth(#4/10/1996#) = #4/1/1996#
    Format$(#4/1/1996#, "ddd") = "Mon"
    FirstBusinessDayOfMonth(#4/10/1996#) = #4/1/1996#

Parameters

Parameter Description
vDate The date whose month and year components are examined to determine the first business day of the month. Function returns Null if vDate is Null or cannot be fixed up to a Date. Function assumes that the business days are Monday through Friday. When the date falls on a weekend, the function returns the date of the next Monday.