Excel formula to display ONLY month and year

Question

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

User · Accepted Answer

There are a number of ways to go about this. One way would be to enter the date 8/1/2013 manually in the first cell (say A1 for example's sake) and then in B1 type the following formula (and then drag it across):

=DATE(YEAR(A1),MONTH(A1)+1,1)

Since you only want to see month and year, you can format accordingly using the different custom date formats available.

The format you're looking for is YY-Mmm.

User · Answer

Try the formula   TEXT TODAY    MMYYYY

User · Answer

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

User · Answer

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

[excel] Excel formula to display ONLY month and year?

Examples related to excel

Examples related to excel-formula