How to input Jan & have a series filled in for the rest of months

M

Michael_needs_help

I want to be able to input any month (in the form Jan, Feb etc) and have
Excel automatically fill the rest of the months in.
 
B

Bernie Deitrick

Type Jan into a cell, select the cell, click the fill handle and pull down.
Excel has a list months that it will then fill into the cells.

If you want to type Jan into cell A1, and have the rest of the cells
automatically filled, then in cell A2, use the formula

=TEXT(DATE(2005,MONTH(DATEVALUE(A1&" 1, 2005"))+1,1),"mmm")

and copy down as far as you need the list.

HTH,
Bernie
MS Excel MVP
 
B

Barb R.

You'll have to enter two sequential months and it will work.

Select the cells, click on the "square" in the lower RH corner and drag
down.

Does that do what you want?
 
Top