Adding one month to noncontiguous cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

wmjenner - 15 Jun 2006 18:06 GMT

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

Signature

wmjenner

Reply to this Message

Gary L Brown - 15 Jun 2006 19:10 GMT

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,

Signature

Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.

> Is there a way to add a month to a series of data that is not
> contiguous? Example:
[quoted text clipped - 9 lines]
>
> Thanks

Reply to this Message

wmjenner - 15 Jun 2006 19:51 GMT

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

Signature

wmjenner

Reply to this Message

Gary L Brown - 15 Jun 2006 20:20 GMT

Great. Please rate me

Signature

Gary Brown
gary_brown@ge_NOSPAM.com
If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.

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

Reply to this Message