date format and list between 2 values

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.

Hello Adsup01,

I created a list of the months in F1:F12. (You can put this anywhere).

I then created a Named Range called Mth with this formula:

=OFFSET(Sheet1!$F$1,VALUE(RIGHT(Sheet1!$A$1,2))-1,0,(VALUE(RIGHT(Sheet1!$A$2,2))+1)-VALUE(RIGHT(Sheet1!$A$1,2)))

This creates a dynamic range which varies according to the YYYYMM entry you have in A1 and A2.

You then create a Data Validation dropdown using the Named Range mth

I hope this helps, please let me know!

Regards,

David


- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

Thank you both very much for help.

You're welcome! Did it work?

Please take the time to mark the thread as SOLVED (see below).

Regards,

David


- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".