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 […]