Workday Function

[Kintantay]

I’m creating an order lead time spreadsheet using the “Workday” function.
A1 – Beginning date. Date entered in cell: Wed 9/07/11
B2 – Enter lead time (usually in 5 day increments) lead time entered in cell: 10
C2 – Result field containing the formula =WORKDAY(A1,B2,H11:H28) results = Fri 10/7/11
H11:H28 are holiday and non manufacturing days and/or weeks. Currently I have the following dates in these cells: Sept 5 – 9, 12 – 16 and 19 – 23. The result I get in cell C2 is correct however what I’m trying to achieve is somewhat different. Since the start date is Wed 9/7/11 I would like the 10 day lead time calculation to begin on the next available Weds, in this case Wed 9/28/2011 then add the 10 starting from that date. If the start date was Thur 9/8/2011 again the 10 lead should begin calculating from 9/29/11. Is there a simple way of doing this? Thank in advance…

Kin

 

[Misca]

Maybe something like: =WORKDAY(A1,MATCH(WEEKDAY(A1),WEEKDAY(WORKDAY(A1,INDEX(ROW($A$1:$A$7),),$H$11:$H$25)))+B2,$H$11:$H$25)

 

[Kintantay]

Thanks for your timely response. I will give it a try.

 

[Kintantay]

I tried the formula and I keep receiving and #VALUE error. Any suggestions.