Help w Month/Year Formula

[mdillon07]

I need a little help creating the correct formula.

Column A: mm/dd/yyyy
Column B: the following formula that is currently producing just the month
=CHOOSE(MONTH(A2),"January","February","March","April","May","June","July","August","September","October","November","December")

I would like to adjust the formula to have it show: October 2017 vs October 2018. I don't really care if its by "October 2017" or "10-17" or "Oct-17" - just want the Month and Year both present.

Thank you!

[Mark.]

try this.

=CHOOSE(MONTH(A2),"January","February","March","April","May","June","July","August","September","October","November","December")&" "&CONCATENATE(YEAR(A2))

[BC_Programmer]

you can also use something like:

Code: [Select]

=TEXT(A2,"MMMM/YYYY")

Or, you can just have it =A2 and then format that cell to use the appropriate date format you desire.