This is the formula I have. I am making a macro including this formula and I don't want to have to type it in manually every time I try to make the macro. Anyone have a way to make this more concise?
=IF((LEFT(C2,3))="Jan", 1, IF((LEFT(C2,3))="Feb", 2, IF((LEFT(C2,3))="Mar",3, IF((LEFT(C2,3))="Apr", 4, IF((LEFT(C2,3))="May", 5, IF((LEFT(C2,3))="Jun", 6, IF((LEFT(C2,3))="Jul", 7, IF((LEFT(C2,3))="Aug", 8, IF((LEFT(C2,3))="Sep", 9, IF((LEFT(C2,3))="Oct", 10, IF((LEFT(C2,3))="Nov", 11, IF((LEFT(C2,3))="Dec", 12,))))))))))))
Bookmarks