Adding one month to noncontiguous cells

W

wmjenner

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
 
G

Gary L Brown

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'.
Tools>Add-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,
 
Top