Months

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Khalil Handal - 12 Sep 2006 19:36 GMT

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

Reply to this Message

Don Guillett - 12 Sep 2006 19:44 GMT

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)

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

> Hi,
> Is there a way (formula or whatever) to have the 12 months instead of
[quoted text clipped - 6 lines]
>
> Khalil Handal

Reply to this Message

Khalil Handal - 12 Sep 2006 20:02 GMT

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

> one way would be to put a date formatted as MMM in b2>put =b2+32 copy
> across.
[quoted text clipped - 10 lines]
>>
>> Khalil Handal

Reply to this Message

Don Guillett - 12 Sep 2006 22:25 GMT

glad to help

Signature

Don Guillett
SalesAid Software
dguillett1@austin.rr.com

> Hi,
> Ron, I did what you said it worked well. the problem for not working at
[quoted text clipped - 19 lines]
>>>
>>> Khalil Handal

Reply to this Message