Looking for an excel formula that will display "13-Aug" and means August of 2013. I would ideally want to copy the "13-Aug" cell to the 11 cells on its right, incrementing the month and appropriate year each time, so it would look like:
"13-Aug", "13-Sep", ..., "13-Dec", "14-Jan", "14-Feb"
This question is related to
excel
excel-formula
First thing first. set the column in which you are working in by clicking on format cells->number-> date and then format e.g Jan-16 representing Jan, 1, 2016. and then apply either of the formulas above.
Try the formula
=TEXT(TODAY(),"MMYYYY")
Very easy, trial and error. Go to the cell you want the month in. Type the Month, go to the next cell and type the year, something weird will come up but then go to your number section click on the little arrow in the right bottom and highlight text and it will change to the year you originally typed
Source: Stackoverflow.com