Function Dates Times Class

NextWeekday

Returns the next weekday (Monday through Friday) after the specified date.

Signature (Visual Basic / VBA)

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

Code Example

    Weekday(#1/3/96#) = vbWednesday
    Weekday(#1/8/96#) = vbMonday
    NextWeekday(#1/3/96#) = #1/4/96#
    NextWeekday(#1/4/96#) = #1/5/96#
    NextWeekday(#1/5/96#) = #1/8/96#
    NextWeekday(#1/6/96#) = #1/8/96#
    NextWeekday(#1/7/96#) = #1/8/96#
    NextWeekday(#1/8/96#) = #1/9/96#

Parameters

Parameter Description
vDate The date whose following weekday (Monday through Friday) is returned. Function returns Null if vDate is Null or cannot be interpreted as a Date.

Notes & Version History

v2.0 Addition This function is new to this version of Entisoft Tools.