How to Convert Month Name to Number in Excel
Numbers 1-12 can be converted to their corresponding month names using the TEXT function. We need to multiply the number by 28 to convert it into a corresponding serial number understandable by the computer.
Formula:
= TEXT(B12 * 28, “mmm”) will return the abbreviated month name (upto three letters) i.e. Apr for April
= TEXT(B12 * 28, “mmmm”) will return the full month name i.e. November, December etc.
The month name can be extracted from a date format as well. For example:
= TEXT(DATE(2016, B12, 7), “mmm”)
Here year and date are given whereas, B12 contains the month number. DATE will convert this information to a valid date code, from which TEXT will extract the month name.
Example:
Using MONTH and EOMONTH functions in Excel
In this easy-to-follow guide, we’ll explore the Excel MONTH and EOMONTH functions. These functions are super handy for working with dates. We’ll show you how to use them to figure out which month a date belongs to, get the first and last day of a month, and more. Whether you’re new to Excel or an experienced user, this tutorial will help you become a pro at handling dates in your spreadsheets. By the end, you’ll be able to breeze through date-related tasks and make your Excel work even smoother. So, let’s dive in and master these functions together!
MONTH and EOMONTH are built-in functions in Excel that assist users in performing date-based operations, particularly those tied to months. Let’s delve into each function and see how they can be useful:
Contact Us