add business days

[janus67]

hello, I have 2 columns of dates
I want to find the number of business days ( ignore holidays) between ColA + ColB
then add the number of days resulting back to ColB ( date or cell No ) to show a future date

I used networkdays to get the difference but can't get the rest in business days

 

[Aladin Akyurek]

You can't have in B1:

B1+(B1-A1)

what you seem to suggest. Care to clarify?

 

[janus67]

ColA 27--17

ColB 11-2-17

as I want business days --I used =networkdays A4,B4) ------gives a positive answer of 11 business days between

now I want to project 11 business days from ColB ( which will be a constant number

 

[janus67]

mistake

ColA is 27-1-17

 

[Aladin Akyurek]

mistake

ColA is 27-1-17

Let's say that:

A4 is 27-1-2017

B4 is 11-2-2017

Now what?

 

[janus67]

post # 3 clearly explains what I want

ColC=(Cola -ColB)+ ColB ----- in BUSINESS DAYS

 

[Aladin Akyurek]

post # 3 clearly explains what I want

ColC=(Cola -ColB)+ ColB ----- in BUSINESS DAYS

Are you not wanting this per record/per row? If so, no need for ColA, ColB, and ColC confusion.

In C4 enter and copy down:

=WORKDAY(B4,NETWORKDAYS(A4,B4,Holidays),Holidays)

where Holidays stand for a range of dates which must be excluded. If there is no such a range, it can be omitted from the formula.

Is this what you are after?

 

[janus67]

yes, that works well

thanks for your help

 

[Aladin Akyurek]

yes, that works well

thanks for your help

You are welcome.