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