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.
