Syntax:
LastDateOfDayInQuarter(dateexpr, NumZ{day})
Description:
Returns the date of the last instance of the specified day in the quarter
of the date specified. For example, this function
could return the date of the last Monday of the next quarter.
Parameter Description
dateexpr A the date to be used when determining the last instance of the quarter.
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 quarter.
lastSundayofthisquarter= LastDateOfDayInQuarter(Now(),1)
'return the date of the last Friday
of next quarter.
lastMondayofnextquarter = LastDateOfDayInQuarter(DateAdd(1,"q",Now()),6)
See Also: