MONTH( )
Topic group Related topics Example
Returns the number of the month for a specified date.
Syntax
MONTH(<expD>)
<expD>
The date whose corresponding month number you want to return.
Description
MONTH( ) returns a date’s month number:
|
Month |
Number |
|
January |
1 |
|
February |
2 |
|
March |
3 |
|
April |
4 |
|
May |
5 |
|
June |
6 |
|
July |
7 |
|
August |
8 |
|
September |
9 |
|
October |
10 |
|
November |
11 |
|
December |
12 |
To return the name of the month instead of the number, use CMONTH( ). MONTH( ) returns zero for a blank date.