Syntax 

Month(dateexpr)


Group 

Time/Date 


Description 

Return the month of the year (1 to 12).


Parameters

Description

dateexpr 

Return the month of the year for this date value. If this value is Null then Null is returned.


See Also 

Date( ), Day( ), MonthName( ), Weekday( ), Year( )


Example

Sub Main

    Debug.Print Month(#1/1/1900#) ' 1

    Debug.Print Month(#2/1/1900#) ' 2

End Sub