LastDayOfMonth
Syntax
LastDayOfMonth(dateexpr)
Description
Returns the last day (for example, Sunday, Monday, etc.) of the month specified by dateexpr. For example, this function could return the name of last day of the current month.
Parameters
| Parameter | Description |
|---|---|
| dateexpr | The date to be used when determining the last day of the current month. |
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 name of the last day of this month
lastDayOfTheMonth = LastDayOfTheMonth (Now())
End Sub
See also
IsLeapYear, FirstDateOfDayInMonth, FirstDateOfDayInQuarter, FirstDateOfDayInYear, LastDateOfDayInMonth, LastDateOfDayInQuarter, LastDateOfWeek, LastDayOfQuarter