Export (0) Print
Expand All

Month Function

Returns a whole number between 1 and 12, inclusive, representing the month of the year.


                      Month(
                      date
                      )
                    

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

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.

Community Additions

Show:
© 2015 Microsoft