|
Answer» 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!try this.
=CHOOSE(MONTH(A2),"January","February","March","April","May","June","July","August","September","October","November","December")&" "&CONCATENATE(YEAR(A2))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.
|
