Add months with rules.....

[buddy1000]

I have this formula..

=WORKDAY(DATE(YEAR($Z$10),MONTH($Z$10)+6,DAY($Z$10)+0)-1,1,'Holidays'!A2:A60)

It looks at date Z10 and adds 6 months. If this results is a weekend or a holiday it returns the next workday. In column Z, I have different dates. Now I have to change the 6 to 12 to 18 months etc. etc.

Is it possible to alter it to do this automatic? I tried to use rOW but got lost a bit.

Any ideas?

 

[Yard]

Hi, assuming this formula is in B1, then try this instead and copy down:

=WORKDAY(DATE(YEAR($Z$10),MONTH($Z$10)+6*(ROW()-ROW($A$1)+1),DAY($Z$10)+0)-1,1,'Holidays'!$A$2:$A$60)

NB I locked your Holidays range as well.