How to Extract Month from Date in Google Sheets

To extract the month from a date in Google Sheets, you can use the MONTH function. The MONTH function returns the month of a specified date as a number between 1 and 12.

Here's how to use the MONTH function:

1. Open your Google Sheets document.
2. Click on a cell where you want to display the extracted month.
3. Type the formula =MONTH(date) in the cell, where "date" is the cell reference containing the date you want to extract the month from. For example, if the date is in cell A1, the formula would be =MONTH(A1).
4. Press Enter to apply the formula.

The extracted month will now be displayed in the selected cell as a number between 1 and 12.

Example

Let's say you have the following date in cell A1: 8/24/2021.

To extract the month (August) from this date, follow these steps:

1. Click on the cell where you want to display the extracted month (e.g., cell B1).
2. Type the formula =MONTH(A1) in cell B1.
3. Press Enter to apply the formula.

The number 8 (representing August) will now be displayed in cell B1.