Syntax:
LastDateOfWeek(dateexpr, NumZ{day})
Description:
Returns the date of the last instance of the specified day in the week
of the date specified.
Parameter Description
dateexpr A the date to be used when determining the last instance of the day in the week.
NumZ{day} The day to check for.
• vbSunday (1) - Sunday
• vbMonday (2) - Monday
• vbTuesday (3) - Tuesday
• vbWednesday (4) - Wednesday
• vbThursday (5) - Thursday
• vbFriday (6) - Friday
• vbSaturday (7) - Saturday
Example:
Sub
Main
'return the date of the last Sunday of this week.
lastSundayofthisweek = LastDateOfWeek(Now(),1)
'return the date of the last Friday of this
week.
lastMondayofthisweek = LastDateOfWeek(Now(),6)
See Also