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