\<bookmark_value\>Month function\</bookmark_value\>

Month Function

Returns the month of a year from a serial date that is generated by the DateSerial or the DateValue function.


Month (Number)

Return value:



\<emph\>Number:\</emph\> Numeric expression that contains the serial date number that is used to determine the month of the year.

This function is the opposite of the \<emph\>DateSerial \</emph\>function. It returns the month in the year that corresponds to the serial date that is generated by \<emph\>DateSerial\</emph\> or \<emph\>DateValue\</emph\>. For example, the expression

Print Month(DateSerial(1994, 12, 20))

returns the value 12.

Error codes:

5 Invalid procedure call


Sub ExampleMonth
    MsgBox "" & Month(Now) ,64,"The current month"
End Sub

Please support us!