Excel Tutorial – MONTH

The MONTH function in Microsoft Excel is a function that extracts the month from a date. This can be useful if you want to perform calculations based on the month or if you want to extract specific months from a list of dates.

To use the MONTH function, follow these steps:

1. Open your Excel workbook and navigate to the cell where you want to apply the MONTH function.
2. Type “=MONTH(” into the cell, followed by the cell reference or date that you want to extract the month from. For example, if you want to extract the month from the date in cell A1, you would type “=MONTH(A1)”.
3. Press the “Enter” key to complete the formula. The cell will now display the month of the year.

Here’s an example of how you can use the MONTH function in a formula:

=IF(MONTH(A1)=1, “January”, “Not January”)

In this example, the MONTH function is used to extract the month from the date in cell A1. The IF function then checks if the month is January and displays “January” if it is, or “Not January” if it is not.

You can also use the MONTH function in conjunction with other date functions, such as the DAY and YEAR functions, to extract the day and year from a date. For example:

=MONTH(A1)&”/”&DAY(A1)&”/”&YEAR(A1)

This formula would extract the month, day, and year from the date in cell A1 and combine them into a new date in the format “mm/dd/yyyy”.