Days between excluding Chinese New Year

[RICHARD_B]

Hi

This is my first post on this forum.

I am trying to write a formula for working out the date for when to place an order. The criteria is a delivery date (Cell A1) and production lead time (Cell B1). Therefore a1-b1. Simple, why am I asking help with this!

......However, I need to exclude Chinese New Year (CNY) when the factories are closed and I don't want to exclude weekends. For example the factory is closed 1st Feb 2016 - 14th Feb 2016 and I want production complete by 21st Feb 2016 with 14 days production time the answer would be 24th Jan (I think that the correct answer counting it in my head!)

Any assistance would be greatly appreciated.

Thanks
RB

 

[Jonmo1]

Which version of Excel do you have?
XL2010+ you could try

=WORKDAY.INTL(A1,-B1,"0000000",G1:G14)

G1:G14 you plug in the dates you want excluded (Feb 1st through Feb14th)

 

[RICHARD_B]

Many Thanks.

That seems to work perfectly.
RB