Month
Month(date)
Description
Month returns a whole number ranging from 1 to 12 that represents the month of the year, of a given date.The required parameter, date, can be any numeric or string expression, or any expression that represents a date.
Example
Rem Month Example
'Month returns month of year of a date
Dim When
When = Now
Print "The Month of " & When & " is " _
& Month(When)
Output
The Month of 8/18/1998 10:52:44 PM is 8 (sample date output is system dependant)