LastDayOfYear |
Syntax:
LastDayOfYear(dateexpr)
Description:
Returns the last day (i.e. Sunday, Monday, etc.) of the year specified by dateexpr. For instance, this function could return the name of last day of the current year.
Parameters:
|
Parameter |
Description |
|
A date which contains the year to be examined. |
The return integer can be one of the following:
|
Firstday |
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 year
lastDayOfYear = LastDayOfYear (Now())
EndSub
See Also
IsLeapYear, FirstDateOfDayInMonth, FirstDateOfDayInQuarter, FirstDateOfDayInYear, LastDateOfDayInMonth, LastDateOfDayInQuarter, LastDateOfWeek, LastDayOfQuarter