LastDayOfQuarter |
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 the second quarter of the current year. A quarter occurs every three months starting in January.
Parameters:
|
Parameter |
Description |
|
The date to be used when determining the last day of the quarter. |
The return integer can be 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 name of the last day of this quarter
lastDayOfThisQuarter = LastDayOfQuarter (Now())
EndSub
See Also
IsLeapYear, FirstDateOfDayInMonth, FirstDateOfDayInQuarter, FirstDateOfDayInYear, LastDateOfDayInMonth, LastDateOfDayInQuarter, LastDateOfWeek, LastDayOfMonth, LastDayOfYear