Months

[Khalil Handal]

Hi,
Is there a way (formula or whatever) to have the 12 months instead of typing
them.
I used Jan in cell B2 and Feb in cell C2, selected both cells and then used
the mouse to copy them to the range D2:M2.
Some of the months were Ok but not all of them?

Can any one help?

Khalil Handal

 

[Don Guillett]

one way would be to put a date formatted as MMM in b2>put =b2+32 copy
across.
more properly would be =date(year(b1),month(b1)+1,1)

 

[Khalil Handal]

Hi,
Ron, I did what you said it worked well. the problem for not working at the
begining was that I had some hidden colomns which made the problem.

Don, You formula is actualy what I was looking for.

Thanks for both of you.
Khalil Handal

 

[Don Guillett]

glad to help