LastDateOfWeek |
Syntax:
LastDateOfWeek(dateexpr, NumZ{day})
Description:
Returns the date of the last instance of the specified day in the week of the date specified.
Parameters:
|
Parameter |
Description |
|
The date to be used when determining the last instance of the day in the week. |
|
|
NumZ{day} |
The day to check for. |
The return integer is one of the following:
|
NumZ{day} |
Value |
Description |
|
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)
EndSub
See Also
IsLeapYear, FirstDateOfDayInMonth, FirstDateOfDayInQuarter, FirstDateOfDayInYear, LastDateOfDayInMonth, LastDateOfDayInQuarter, LastDayOfMonth, LastDayOfQuarter, LastDayOfYear