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

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.
 
F

Fred Smith

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top