#### buddy1000

##### Active Member
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?

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.
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.

Replies
8
Views
431
Replies
5
Views
358
Replies
5
Views
387
Replies
13
Views
623
Replies
2
Views
85

1,216,099
Messages
6,128,823
Members
449,470
Latest member
Subhash Chand

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back