date format and list between 2 valued

[Adsies]

Hi All,

2 quickies (I hope):

1. Want to turn 201607 into a Month format "Jul" - whats best formula?

2. Once I have identified a start month ex. Jan (in that format) in cell A1 and end month Sep (in that format) in cell A2 I want to create a list with all the months that fall between cell A1 value and cell A2 value in "Mmm" format.
This list will utilized in a data validation drop down list.

Thank you very much.

 

[Muhammad_Usman]

Formula is

DATE(0,RIGHT(A2,2)+1,0)