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


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