The MONTH function in Excel returns an integer from 1 to 12, representing January to December. For example, type the formula "= MONTH(TODAY())" or "=MONTH(NOW())" without the quotation marks in a cell to display the current month number.
Note that date values are not compatible between the Windows and Macintosh versions of Excel. If you create a workbook with date values in one version and open it in the other version, the date values may be incorrect.
Date Data Type
Excel has a special data type to represent a date called Date. Ensure the value you pass to the MONTH function is a Date value by using a function that returns a Date value. There are several functions that convert text into a Date value, such as the DATE and the DATEVALUE functions. For example, type any of the following equivalent formulas into a cell to display the number seven for the month of July:
\=MONTH(DATEVALUE("07/04/2015")) \=MONTH(DATEVALUE("July 4, 2015")) \=MONTH(DATEVALUE("7/4/2015")) \=MONTH(DATEVALUE("07-04-15")) \=MONTH(DATE(2015, 7, 4))