| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 __ |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 __ |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
|
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#13
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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) |
|
#14
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#15
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#16
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#17
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 row height format | Excel Discussion (Misc queries) | |||
| Very slow in opening Excel 97 file in Excel 2003 | Setting up and Configuration of Excel | |||
| Excel Re-calculation 2000 compared to 2003 | Excel Discussion (Misc queries) | |||
| Excel 2003 crashes loading excel files created Excel 2000 | Excel Discussion (Misc queries) | |||
| sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
Linear Mode
