How to add months

[PRIMA]

Guys,

How to add the month? Example: January 2008 then next is February, March, April, May 2008 so on & so forth.

I dont want to use the Edit --> Fill function, what I want is to Add a number of days. Is there an easy way to do this?

I need your help. Thank you.

Prima

 

[VoG]

Does this help - A1 contains 1/1/2009 and the cells are custom formatted as mmmm yyyy

<b>Sheet4</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:116px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >A</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >1</td><td style="text-align:right; ">January 2009</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >2</td><td style="text-align:right; ">February 2009</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >3</td><td style="text-align:right; ">March 2009</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >4</td><td style="text-align:right; ">April 2009</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >5</td><td style="text-align:right; ">May 2009</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >6</td><td style="text-align:right; ">June 2009</td></tr><tr style="height:18px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >7</td><td style="text-align:right; ">July 2009</td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b>Spreadsheet Formulas</b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >A2</td><td >=DATE(YEAR<span style=' color:008000; '>(A1)</span>,MONTH<span style=' color:008000; '>(A1)</span>+1,DAY<span style=' color:008000; '>(A1)</span>)</td></tr><tr><td >A3</td><td >=DATE(YEAR<span style=' color:008000; '>(A2)</span>,MONTH<span style=' color:008000; '>(A2)</span>+1,DAY<span style=' color:008000; '>(A2)</span>)</td></tr><tr><td >A4</td><td >=DATE(YEAR<span style=' color:008000; '>(A3)</span>,MONTH<span style=' color:008000; '>(A3)</span>+1,DAY<span style=' color:008000; '>(A3)</span>)</td></tr><tr><td >A5</td><td >=DATE(YEAR<span style=' color:008000; '>(A4)</span>,MONTH<span style=' color:008000; '>(A4)</span>+1,DAY<span style=' color:008000; '>(A4)</span>)</td></tr><tr><td >A6</td><td >=DATE(YEAR<span style=' color:008000; '>(A5)</span>,MONTH<span style=' color:008000; '>(A5)</span>+1,DAY<span style=' color:008000; '>(A5)</span>)</td></tr><tr><td >A7</td><td >=DATE(YEAR<span style=' color:008000; '>(A6)</span>,MONTH<span style=' color:008000; '>(A6)</span>+1,DAY<span style=' color:008000; '>(A6)</span>)</td></tr></table></td></tr></table> <br />Excel tables to the web - Excel Jeanie Html 4

 

[PRIMA]

Hi VoG,

Thank you very much for your help..I got it.

Regards,

Prima

 

[PhilJC]

I have been trying to do something similar to the original poster so was very happy to find this thread as I'd not really played with the DATE function before (still learning Excel!) but when I use a start date of 31/Jan/2009 as my start date and I try the above I keep losing months from my list - which is a pain!

Is there any other ways I can increment by a month?

Many thanks in advance!

 

[VoG]

Perhaps this

<b>Sheet1</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:75px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td style=" border-width:3px; border-styleutset;border-color:#f0f0f0; ">A</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >1</td><td style="text-align:right; ">31/01/2009</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >2</td><td style="text-align:right; ">28/02/2009</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >3</td><td style="text-align:right; ">31/03/2009</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >4</td><td style="text-align:right; ">30/04/2009</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >5</td><td style="text-align:right; ">31/05/2009</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >6</td><td style="text-align:right; ">30/06/2009</td></tr><tr style="height:18px ;" ><td style="border-width:3; border-styleutset;border-color:#f0f0f0; background-color:#cacaca; text-align:center; " >7</td><td style="text-align:right; ">31/07/2009</td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b>Spreadsheet Formulas</b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >A2</td><td >=EOMONTH(A1,1)</td></tr><tr><td >A3</td><td >=EOMONTH(A2,1)</td></tr><tr><td >A4</td><td >=EOMONTH(A3,1)</td></tr><tr><td >A5</td><td >=EOMONTH(A4,1)</td></tr><tr><td >A6</td><td >=EOMONTH(A5,1)</td></tr><tr><td >A7</td><td >=EOMONTH(A6,1)</td></tr></table></td></tr></table> <br />Excel tables to the web - Excel Jeanie Html 4

EOMONTH requires the Analysis Toolpak from Tools > Add-ins.

 

[PhilJC]

That is absoloutely perfect! Thankyou very much!