increase one month

[leiliang217@yahoo.com]

Hello All,

Is there any formula which can increase the above cell by one month.
For example,

The sheet looks like this,

January
=formula -------------> February
=formula--------------> March
..
..
..
=formula---------------> December

Thanks

[Sandy Mann]

If you just want a list of the months then you don't need a formula at all.
Just enter January in a cell, hover the cursor over the bottom right-hand
corner where the fill handle is, then when the cursor changes to a black
cross-hair, left-click and hold the button pressed while you drag down the
column to get a list of months.

If you want a formula then enter the "January" as a date ie 1/1/06 and then
below it the formula =DATE(YEAR(J20),MONTH(J20)+1,1) and Custom format the
cells as "mmmm" (without the quotations)

--
HTH

Sandy
sandymann2@mailinator.com
Replace@mailinator.com with @tiscali.co.uk


<leiliang217@yahoo.com> wrote in message
news:1143752947.556003.322740@v46g2000cwv.googlegroups.com...
> Hello All,
>
> Is there any formula which can increase the above cell by one month.
> For example,
>
> The sheet looks like this,
>
> January
> =formula -------------> February
> =formula--------------> March
> .
> .
> .
> =formula---------------> December
>
> Thanks
>

[Peo Sjoblom]

If January is just a text value just grab the lower right corner of the cell
and copy down and it will increase the months, if it is a date

=TEXT(DATE(YEAR($A$1),MONTH($A$1)+ROWS($A$1:A1),1),"mmmm")

copy down



--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com




<leiliang217@yahoo.com> wrote in message
news:1143752947.556003.322740@v46g2000cwv.googlegroups.com...
> Hello All,
>
> Is there any formula which can increase the above cell by one month.
> For example,
>
> The sheet looks like this,
>
> January
> =formula -------------> February
> =formula--------------> March
> .
> .
> .
> =formula---------------> December
>
> Thanks
>

[Zack Barresse]

Hi there,

It depends on what is in the cell as a value. If it is a date, then you can
use something like this...

For text:
=TEXT(DATE(YEAR(A1),MONTH(A1)+1,1),"mmmm")

For a date:
DATE(YEAR(A1),MONTH(A1)+1,1)
Which you'll need to format (select it & Ctrl + 1) it as Custom: "mmmm" (w/o
quotes).

HTH

--
Regards,
Zack Barresse, aka firefytr
To email, remove NOSPAM



<leiliang217@yahoo.com> wrote in message
news:1143752947.556003.322740@v46g2000cwv.googlegroups.com...
> Hello All,
>
> Is there any formula which can increase the above cell by one month.
> For example,
>
> The sheet looks like this,
>
> January
> =formula -------------> February
> =formula--------------> March
> .
> .
> .
> =formula---------------> December
>
> Thanks
>

[Peo Sjoblom]

"Zack Barresse" <firefytrNO@SPAMvbaexpress.com> wrote in message
news:evZ$WAEVGHA.6084@TK2MSFTNGP14.phx.gbl...
> Hi there,
>
> It depends on what is in the cell as a value. If it is a date, then you
> can use something like this...
>
> For text:
> =TEXT(DATE(YEAR(A1),MONTH(A1)+1,1),"mmmm")

will only work in the first cell then it will return a value error since the
second formula will be working with text and YEAR, MONTH and DAY will throw
an error for text



--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

[Zack Barresse]

True. I should have mentioned that. Thanks Peo.

Maybe I should have made that ...

For text:
=TEXT(DATE(YEAR($A$1),MONTH($A$1)+ROW(A1),1),"mmmm")

--
Regards,
Zack Barresse, aka firefytr
To email, remove NOSPAM


"Peo Sjoblom" <peo.sjoblom@nw^^excelsolutions.com> wrote in message
news:OeJ5$CEVGHA.4952@TK2MSFTNGP09.phx.gbl...
>
> "Zack Barresse" <firefytrNO@SPAMvbaexpress.com> wrote in message
> news:evZ$WAEVGHA.6084@TK2MSFTNGP14.phx.gbl...
>> Hi there,
>>
>> It depends on what is in the cell as a value. If it is a date, then you
>> can use something like this...
>>
>> For text:
>> =TEXT(DATE(YEAR(A1),MONTH(A1)+1,1),"mmmm")
>
> will only work in the first cell then it will return a value error since
> the second formula will be working with text and YEAR, MONTH and DAY will
> throw an error for text
>
>
>
> --
>
> Regards,
>
> Peo Sjoblom
>
> http://nwexcelsolutions.com
>
>
>