How to Use the MONTH Formula in Excel to Extract Month from a Date

Learn how to use the Excel MONTH formula to extract the month number from any date quickly and accurately.

94 views

The formula to extract or convert a date to a month number in Excel is `=MONTH(serial_number)`. Here, `serial_number` refers to the date you want to extract the month from. For example, `=MONTH("August 23, 2023")` will return `8`, indicating the month of August. For a text representation of the month, consider using `=TEXT(A1, "mmm")` or `=TEXT(A1, "mmmm")` where `A1` contains the date.

FAQs & Answers

  1. What does the MONTH function do in Excel? The MONTH function in Excel extracts the month number (1-12) from a given date value.
  2. How can I display the month name instead of the month number in Excel? You can use the TEXT function with a date cell, e.g., =TEXT(A1, "mmm") for abbreviated month or =TEXT(A1, "mmmm") for full month name.
  3. Can the MONTH function handle text dates in Excel? The MONTH function works with valid Excel date serial numbers. Text dates need to be converted to date format before use.
  4. How do I extract the month from a date string like 'August 23, 2023'? You can directly use =MONTH("August 23, 2023") to get the month number 8, or convert the string to a date serial if necessary.