Syntax:
LastDayOfMonth(dateexpr)
Description:
Returns the last day (i.e. Sunday, Monday, etc.) of the month specified
by dateexpr. For example, this function could return
the name of last day of the current month. 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 month to be examined
Example:
Sub
Main
'return the name of the last day of this month
lastDayOfTheMonth = LastDayOfTheMonth (Now())
End Sub
See Also