Function Dates Times Class

LastDayOfWeek

Returns the last day of the week (the Saturday) for the given date. Returns vDate if it is already the last day of the week.

Signature (Visual Basic / VBA)

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

Code Example

    LastDayOfWeek(#1/12/96#) = #1/13/96#
    LastDayOfWeek(#1/13/96#) = #1/13/96#
    LastDayOfWeek(#1/14/96#) = #1/20/96#
    LastDayOfWeek(#1/20/96#) = #1/20/96#
    LastDayOfWeek(#1/21/96#) = #1/27/96#

Parameters

Parameter Description
vDate The date used to determine the week whose last day is returned. Function returns Null if vDate is Null or cannot be fixed up to a Date.

Notes & Version History

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