how do i set a column as a month in a function

  • Thread starter Thread starter sunderhill20
  • Start date Start date
S

sunderhill20

I am able to have info arranged in column 1 according to the date. Example,
Cell 1A = 1st day of the month, Cell 2A = 2nd day of the month. How do I make
column 2 equal February, column 3 equal march etc.
 
It depends whether you want a date or text.

If you want Text, Enter Jan in A1, then use the fill handle to drag it.
Excel will fill in the months automatically.

If you want dates, enter any date in January in A1. Format as mmm.
In A2, enter =date(year(a1),month(a1)+1,day(a1))
copy down as needed.

Regards,
Fred
 
Back
Top