The Excel MONTH Function


Basic Description

The Excel MONTH function, when supplied with a date, returns an integer representing the month of the year (from 1 - 12).

The format of the function is :

MONTH( date )

where the date argument can be supplied to the function as either :

or

Warning: If you attempt to input the date argument as text, there is a chance that Excel may misinterpret this, depending on the date system, or date interpretation settings on your computer.

Also, although you can input the date as a serial number, this is not recommended, as the serial numbers may vary across different computer systems.


Month Function Examples

The following example shows the month function used to extract the month from 3 different dates. The spreadsheet on the left shows the format of the function and the spreadsheet on the right shows the results for the 3 dates.

 Formulas:
  A B
1 29-May-2008 =MONTH( A1 )
2 05-Mar-1984 =MONTH( A2 )
3   =MONTH( DATE(2010, 7, 1) )
 Results:
  A B
1 29-May-2008 5
2 05-Mar-1984 3
3   7

Note that, in the above examples, as recommended by Microsoft, the date value is always supplied as either a reference to a cell containing a date, or as a value returned from another function.


Further examples of the Excel Month function can be found on the Microsoft Office website.


Excel Month Function Common Problem

Common Problem:

The result of your Month function looks like a date (eg. "01/01/1900"), instead of returning an integer.

Solution:

This problem arises because the new cell or column is formatted as a 'date'. In this case, it is only the formatting of the cell that is wrong, NOT the value returned by the function.

To correct this,

  • Highlight the cell(s) with the wrong formatting
  • Right click with the mouse
  • Select the Format Cells ... option and ensure the Number tab is selected
  • Under the Category heading, select the option General and click OK

- Read more about Excel Formatting here

Return to the Excel Date and Time Functions Page

Return to the List of All Built-In Excel Functions

Valid XHTML 1.0 Transitional Valid CSS!
Disclaimer   Privacy Policy
Copyright © 2008-2013 ExcelFunctions.net