month plus one - excel 2003

D

DSJR

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)
 
B

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)
 
R

Richard Buttrey

Hi DSJR,

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

HTH
Click to expand...


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

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

and formatted as "mmmm" of course

:)

RB
__
 
D

DSJR

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
 
D

DSJR

I appreciate this!
d

Bob Phillips said:
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)
Click to expand...
 
D

DSJR

thank you for your help!
d

Richard Buttrey said:
Probably a typo, but aren't there some ( ) missing ?

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

and formatted as "mmmm" of course

:)

RB
__
Click to expand...
 
D

daddylonglegs

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

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

DSJR

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

Marcelo

DSJR,

Try

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

regards

Marcelo from Brazil

"DSJR" escreveu:
 
S

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
 
C

Cavy

This formula is working really well for me.

Can someone please explain what the 29 means?

Many thanks!
 
C

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)
 
D

David Biddulph

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