month plus one - excel 2003
 

hi .. I would like to find a formula that will take the current month (i.e.
May) and add one month and return (display) just the following month (i.e.
June)

month plus one - excel 2003
 

Hi DSJR,

=DATE(YEAR(TODAY),MONTH(TODAY)+1,DAY(TODAY())

HTH
--
AP

"DSJR" a écrit dans le message de news:
...
hi .. I would like to find a formula that will take the current month
(i.e.
May) and add one month and return (display) just the following month
(i.e.
June)

month plus one - excel 2003
 

You might want to try this version that caters for the end of the month when
the next month has fewer days

=MIN(DATE(YEAR(TODAY()),MONTH(TODAY())+{2,1},DAY(T ODAY())*{0,1}))

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Ardus Petus" wrote in message
...
Hi DSJR,

=DATE(YEAR(TODAY),MONTH(TODAY)+1,DAY(TODAY())

HTH
--
AP

"DSJR" a écrit dans le message de news:
...
hi .. I would like to find a formula that will take the current month
(i.e.
May) and add one month and return (display) just the following month
(i.e.
June)

month plus one - excel 2003
 

On Sun, 21 May 2006 19:21:38 +0200, "Ardus Petus"
wrote:

Hi DSJR,

=DATE(YEAR(TODAY),MONTH(TODAY)+1,DAY(TODAY())

HTH


Probably a typo, but aren't there some ( ) missing ?

=DATE(YEAR(TODAY()),MONTH(TODAY())+1,DAY(TODAY()))

and formatted as "mmmm" of course

:-)

RB
__

month plus one - excel 2003
 

Ardus .. when I enter this formual I get an error .... is the formula
=DATE(YEAR(TODAY),MONTH(TODAY)+1,DAY(TODAY()) where there is an open/close
parenthesis () after the final today? .. followed by a closed )? Is the HTH
part of the formula?

d

"Ardus Petus" wrote:

Hi DSJR,

=DATE(YEAR(TODAY),MONTH(TODAY)+1,DAY(TODAY())

HTH
--
AP

"DSJR" a écrit dans le message de news:
...
hi .. I would like to find a formula that will take the current month
(i.e.
May) and add one month and return (display) just the following month
(i.e.
June)

month plus one - excel 2003
 

thank you ... got it!
d

"Ardus Petus" wrote:

Hi DSJR,

=DATE(YEAR(TODAY),MONTH(TODAY)+1,DAY(TODAY())

HTH
--
AP

"DSJR" a écrit dans le message de news:
...
hi .. I would like to find a formula that will take the current month
(i.e.
May) and add one month and return (display) just the following month
(i.e.
June)

month plus one - excel 2003
 

I appreciate this!
d

"Bob Phillips" wrote:

You might want to try this version that caters for the end of the month when
the next month has fewer days

=MIN(DATE(YEAR(TODAY()),MONTH(TODAY())+{2,1},DAY(T ODAY())*{0,1}))

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Ardus Petus" wrote in message
...
Hi DSJR,

=DATE(YEAR(TODAY),MONTH(TODAY)+1,DAY(TODAY())

HTH
--
AP

"DSJR" a écrit dans le message de news:
...
hi .. I would like to find a formula that will take the current month
(i.e.
May) and add one month and return (display) just the following month
(i.e.
June)

month plus one - excel 2003
 

thank you for your help!
d

"Richard Buttrey" wrote:

On Sun, 21 May 2006 19:21:38 +0200, "Ardus Petus"
wrote:

Hi DSJR,

=DATE(YEAR(TODAY),MONTH(TODAY)+1,DAY(TODAY())

HTH


Probably a typo, but aren't there some ( ) missing ?

=DATE(YEAR(TODAY()),MONTH(TODAY())+1,DAY(TODAY()))

and formatted as "mmmm" of course

:-)

RB
__

month plus one - excel 2003
 

If you don't mind the result as text, rather than a formatted date you
could use

=TEXT((MONTH(TODAY())+1)*29,"mmmm")


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=544079

month plus one - excel 2003
 

Excellent .. thank you ..
I am not sure of the etiquette of this .. so if wrong, just disregard ..
€˜daddylonglegs .. the movie, Fred Astaire, the spider or €¦.?


"daddylonglegs" wrote:


If you don't mind the result as text, rather than a formatted date you
could use

=TEXT((MONTH(TODAY())+1)*29,"mmmm")


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=544079

month plus one - excel 2003
 

DSJR,

Try

=DATE(YEAR(TODAY()),MONTH(TODAY())+1,DAY(TODAY())

regards

Marcelo from Brazil

"DSJR" escreveu:

Ardus .. when I enter this formual I get an error .... is the formula
=DATE(YEAR(TODAY),MONTH(TODAY)+1,DAY(TODAY()) where there is an open/close
parenthesis () after the final today? .. followed by a closed )? Is the HTH
part of the formula?

d

"Ardus Petus" wrote:

Hi DSJR,

=DATE(YEAR(TODAY),MONTH(TODAY)+1,DAY(TODAY())

HTH
--
AP

"DSJR" a écrit dans le message de news:
...
hi .. I would like to find a formula that will take the current month
(i.e.
May) and add one month and return (display) just the following month
(i.e.
June)

month plus one - excel 2003
 

If you have the Analysis toolpak installed you could use,

=EOMONTH(TODAY(),1)

Format as mmmm.

To install go to Tools menu, Add-Ins and check the Analysis Toolpak
checkbox. Click OK.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=544079

month plus one - excel 2003
 

thank you
d

"Marcelo" wrote:


DSJR,

Try

=DATE(YEAR(TODAY()),MONTH(TODAY())+1,DAY(TODAY())

regards

Marcelo from Brazil

"DSJR" escreveu:

Ardus .. when I enter this formual I get an error .... is the formula
=DATE(YEAR(TODAY),MONTH(TODAY)+1,DAY(TODAY()) where there is an open/close
parenthesis () after the final today? .. followed by a closed )? Is the HTH
part of the formula?

d

"Ardus Petus" wrote:

Hi DSJR,

=DATE(YEAR(TODAY),MONTH(TODAY)+1,DAY(TODAY())

HTH
--
AP

"DSJR" a écrit dans le message de news:
...
hi .. I would like to find a formula that will take the current month
(i.e.
May) and add one month and return (display) just the following month
(i.e.
June)

month plus one - excel 2003
 

thank you
d

"SteveG" wrote:


If you have the Analysis toolpak installed you could use,

=EOMONTH(TODAY(),1)

Format as mmmm.

To install go to Tools menu, Add-Ins and check the Analysis Toolpak
checkbox. Click OK.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=544079

month plus one - excel 2003
 

This formula is working really well for me.

Can someone please explain what the 29 means?

Many thanks!

"daddylonglegs" wrote:


If you don't mind the result as text, rather than a formatted date you
could use

=TEXT((MONTH(TODAY())+1)*29,"mmmm")


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=544079

month plus one - excel 2003
 

Can someone please explain what the 29 means?

The MONTH function returns a number between 1 and 12 indicating the month
number. Multiplying each of those by 29 will give a series of values 29, 58,
87, ..., 219, 348. Each of these is treated as a date (day of year of 1900),
and thus TEXT with the "mmmm" parameter will return the month name for that
date, and you'll get "January", "February"...."December".

To see this in action, enter =ROW()*29 in A1 and =TEXT(A1,"mmmm") in B1 and
fill down to row 12. You'll get month names in B1:B12.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)


"Cavy" wrote in message
...
This formula is working really well for me.

Can someone please explain what the 29 means?

Many thanks!

"daddylonglegs" wrote:


If you don't mind the result as text, rather than a formatted date you
could use

=TEXT((MONTH(TODAY())+1)*29,"mmmm")


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile:
http://www.excelforum.com/member.php...o&userid=30486
View this thread:
http://www.excelforum.com/showthread...hreadid=544079

month plus one - excel 2003
 

I assume that the logic was that day 29*n of the year will always lie in
month n?
--
David Biddulph

"Cavy" wrote in message
...
This formula is working really well for me.

Can someone please explain what the 29 means?

Many thanks!

"daddylonglegs" wrote:


If you don't mind the result as text, rather than a formatted date you
could use

=TEXT((MONTH(TODAY())+1)*29,"mmmm")