Month
Returns a whole number between 1 and 12, inclusive, representing the month of the year.
Syntax
Month(<value>)
Parameters
<value>
Type: Date
The date for which you want to return the month.
(return)
Type: Long
The month of the year (1 to 12).
Notes
This is equivalent to DatePart("m", Val).
Example
This example returns the month from the current date (which is in turn returned by the
Now function). For example, on 20 January 2023, this example returns 1.
Month(Now())
For an example of using the MonthName function with Month and Now to return the name of the current month, see
MonthName.
See also