Syntax:
LastDayOfQuarter(dateexpr)
Description:
Returns the last day (i.e. Sunday, Monday, etc.) of the quarter specified
by dateexpr. For example, this function could return
the name of last day of second quarter of the current year. A
quarter occurs every three months starting in January. The
return integer is one of the following:
vbSunday (1) - Sunday
vbMonday (2) - Monday
vbTuesday (3) - Tuesday
vbWednesday (4) - Wednesday
vbThursday (5) - Thursday
vbFriday (6) - Friday
vbSaturday (7) - Saturday
Parameter Description
dateexpr A date that contains the quarter to be examined
Example:
Sub
Main
'return the name of the last day of this quarter
lastDayOfThisQuarter = LastDayOfQuarter (Now())
End Sub
See Also