Use the MONTH function to extract the month part of a date - Date and Time Functions - Microsoft Excel Tutorials

Use the MONTH function to extract the month part of a date using Microsoft Excel

For this tip use the worksheet from the previous example. Column A contains dates formatted in different ways. To determine the month part of a date, use the MONTH function. This function returns the month corresponding to a date as an integer in the range 1 to 12.

To extract the month part of a date:

1. In cells A2:A10 generate a list of dates using different formats.
2. Select cells B2:B10 and type the following formula:
=MONTH(A2).
3. Press <-Ctrl+Enter->.

Use the MONTH function to extract the month part of a date

Watch the Video Tutorial - https://www.youtube.com/watch?v=JAG3zRuYajU