How to Use Excel's MONTH Function

By Steve McDonnell

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))