When working in Excel, often times you'll want to be pulling a lot of information automatically from dates. There are a few different methods of extracting month information that you should know.
Contents:
Examples
1. How to Extract the Month Number from a Date Using a Formula
Excel has a built-in function that will automatically extract the month number from any date. This will give us the second column, highlighted in table above.
It's as easy as using the MONTH function, and dropping in the date that you wish to extract the month out of.
= MONTH(date)2. How to Extract the Month Name from a Date Using a Formula
What if we instead want to return the names of each month? We can use a simple formula to accomplish this as well.
To return the month names as seen in the third, highlighted, column in the table above, we can use the following formula:
= TEXT(date,"mmmm")The TEXT function will automatically convert any input date (hardcoded or a cell reference) into multiple formats as specified by the text in-between quotations marks in the second argument. In this case, since we need the full month name, we want to use "mmmm". This tells Excel to write out the full month name.
3. How to Extract Abbreviated Month Name from a Date Using a Formula
Similar to the previous example, we can also return the abbreviated month name if needed.
By changing our formula to use three m's instead of four, the TEXT function will automatically return the abbreviated month names:
= TEXT(date,"mmm")