Function Dates Times Class

PreviousWeekday

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

Signature (Visual Basic / VBA)

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

Code Example

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

Parameters

Parameter Description
vDate The date whose previous 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.