for converting a number between 1 to 12 to the corresponding month

Question

for eg, inorder to convert 2 to February or 9 to September, which function to be used?

sergeibaklan · Answer

With this apprach you may use shorter equivalent =SWITCH(G12,1,"Jan",2,"Feb",..."Not Defined")

detlef_lewin · Answer

Hello&nbsp;There are many solutions. Perhaps the shortest would be:&nbsp;=TEXT(DATE(,A1,1);"MMMM")

sergeibaklan · Answer

Detlef, even shorter will be&nbsp;=TEXT(A1*28,"mmmm")

detlef_lewin · Answer

Nice solution, Sergei. It also works with 29 and 30.&nbsp;

sergeibaklan · Answer

Yes, year 1900 was leap one. But that's only for Georgian calendar, perhaps your formula is more correct if use other calendars.

Forum Discussion