Select a Category

How to convert month in text format to date in Excel?

Problem

How to convert month in text format such as “Feb” or “February” to Excel acceptable date?

Solution

Excel provides month function. However, it errors out when it is used as =month(“Feb”). The trick is adding 1 to the end of the text so the formula becomes =month(“Feb” & 1). Excel takes month function accepts “1Feb” or “Feb1” without any problem. Date function takes three values as year, month and day and converts them into a date value as shown below.

001 - Convert Text to Month Value

Comments are closed.