Visual Basic for Applications Reference

Month Function Example

This example uses the Month function to obtain the month from a specified date. In the development environment, the date literal is displayed in short date format using the locale settings of your code.

Dim MyDate, MyMonth
MyDate = #February 12, 1969#   ' Assign a date.
MyMonth = Month(MyDate)   ' MyMonth contains 2.