month plus one - excel 2003

[Guest]

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)

 

[Ardus Petus]

Hi DSJR,

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

HTH

 

[Bob Phillips]

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(TODAY())*{0,1}))

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

 

[Richard Buttrey]

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
__

 

[Guest]

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

 

[Guest]

thank you ... got it!
d

Hi DSJR,

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

HTH

 

[Guest]

I appreciate this!
d

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(TODAY())*{0,1}))

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

 

[Guest]

thank you for your help!
d

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

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

and formatted as "mmmm" of course



RB
__

 

[daddylonglegs]

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

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

 

[Guest]

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 ….?

 

[Guest]

DSJR,

Try

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

regards

Marcelo from Brazil

"DSJR" escreveu:

 

[SteveG]

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

 

[Guest]

thank you
d

DSJR,

Try

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

regards

Marcelo from Brazil

"DSJR" escreveu:

 

[Guest]

thank you
d

 

[Guest]

This formula is working really well for me.

Can someone please explain what the 29 means?

Many thanks!

 

[Chip Pearson]

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)

 

[David Biddulph]

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