I. Intro
You can use the MONTH function to find the month of a date, expressed as an integer.
II. About the function
- Formula: =MONTH(date value)
- Parameters:
- Date value: The date that you want to find the month for.
- Example:
- In a cell, enter =MONTH("2021-6-30") or =MONTH("2021/6/30"). Since the month is June, it will return 6.
- Note:
- Use double quotation marks (") around the date in the formula.
- Set the cell format as either General or Number to ensure the correct results are displayed.
III. Steps
- Select a cell and click Formula in the toolbar, select All functions, and search for MONTH. You can also directly enter =MONTH in a cell.
- Enter the parameters (date value). The year, month, and day can be separated by either a hyphen (-) or a slash (/).
- Press Enter to display the result.
250px|700px|reset