Adding one month to noncontiguous cells
 

Is there a way to add a month to a series of data that is not
contiguous? Example:

Row 1 June 1, 2006
Row 5
Row 9
Row 13

I want a formula in rows 5, 9 and 13 that will add one month to the
value in Row 1 so that if I change that value the others will change as
well.

Thanks


--
wmjenner


------------------------------------------------------------------------
wmjenner's Profile: http://www.excelforum.com/member.php...fo&userid=5282
View this thread: http://www.excelforum.com/showthread...hreadid=552334

Adding one month to noncontiguous cells
 

You are looking for the EDate() function.
You need to activate one of the add-ins that comes with Excel. Why they
don't automatically have it activated is beyond me.
The add-in is called 'Analysis ToolPak'.
ToolsAdd-ins...
Check the 'Analysis ToolPak' and 'AnalysisToolPak-VBA' checkboxes and hit OK.

Now, if A1 = June 1, 2006

=edate(A1,1) will = July 1, 2006
=edate(A1,4) will = October 1, 2006

HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"wmjenner" wrote:


Is there a way to add a month to a series of data that is not
contiguous? Example:

Row 1 June 1, 2006
Row 5
Row 9
Row 13

I want a formula in rows 5, 9 and 13 that will add one month to the
value in Row 1 so that if I change that value the others will change as
well.

Thanks


--
wmjenner


------------------------------------------------------------------------
wmjenner's Profile: http://www.excelforum.com/member.php...fo&userid=5282
View this thread: http://www.excelforum.com/showthread...hreadid=552334

Adding one month to noncontiguous cells
 

Thanks Gary. That's exactly what I was looking for.


--
wmjenner


------------------------------------------------------------------------
wmjenner's Profile: http://www.excelforum.com/member.php...fo&userid=5282
View this thread: http://www.excelforum.com/showthread...hreadid=552334

Adding one month to noncontiguous cells
 

Great. Please rate me
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"wmjenner" wrote:


Thanks Gary. That's exactly what I was looking for.


--
wmjenner


------------------------------------------------------------------------
wmjenner's Profile: http://www.excelforum.com/member.php...fo&userid=5282
View this thread: http://www.excelforum.com/showthread...hreadid=552334