Syntax

Month(date)

The date argument is any expression that can represent a date. If date contains Null, Null is returned.

Remarks
The following example uses the Month function to return the current month:

Dim MyVar
MyVar = Month(Now) ' MyVar contains the number corresponding to the current month.

related to
Date      Day      Now      Weekday      Year