Combining NETWORKDAYS with IF, THEN, OR formulas

[searchingforhelp]

I am having trouble combining formulas and deciphering which formula is best for what is needed. I am currently using the NETWORKDAYS formula, but I cannot connect it with what I am trying to accomplish due to my skill sets.

What I need assistance in is as follows:

1. the formula needs to calculate business days only, excluding weekends.

2. I would need to calculate the days from when the assignment was originally assigned (Column A) to the date when assignment was completed (Column C). However, if there is a reassignment date (column B), have the formula automatically adjust to calculate the reassignment date (Column B) to when the assignment was completed (column C).

3. Lastly, if the reassignment date (Column B) exceeds the assignment completion date, automatically calculate original assigned date (Column A) from when the assignment was completed.

This is where I am stuck. Combining 1,2 and 3 into one formula so I can drag down as more data is entered on the sheet.

Thanking you in advance for any help you can provide.

Example.xlsx
	A	B	C	D
1	Date when Originally assigned	Date when assignment was reassigned	Date when assignment was completed	Number of Days
2	3/10/2021		3/12/2021	3
3	3/10/2021	3/11/2021	3/18/2021	6
4	3/10/2021	3/15/2020	3/11/2021	2
Sheet1

Cell Formulas
Range	Formula
D2,D4	D2	=NETWORKDAYS(A2,C2)
D3	D3	=NETWORKDAYS(B3,C3)

 

[searchingforhelp]

Why should D4 be not & not 1, or have you moved the goalposts again?

So sorry, my apologies, I confused myself. D4 is correct. What about D3? Should it not calculate 2 days? Given that D2 and D4 is calculated correctly.

 

[searchingforhelp]

So sorry, my apologies, I confused myself. D4 is correct. What about D3? Should it not calculate 2 days? Given that D2 and D4 is calculated correctly.

So sorry, my apologies, I confused myself. D4 is correct. What about D3? Should it not calculate 2 days? Given that D2 and D4 is calculated correctly?
I noticed when dragging the formula downward it starts to give me incorrect results. For example row 5 D5. The formula is suppose to calculate A and B given that B does not exceed C.

Copy of Example 2.xlsx
	A	B	C	D	E
1	Date when Originally assigned	Date when assignment was reassigned	Date when assignment was completed	Formula that was provided: =NETWORKDAYS(IF(B2>C2,A2,MAX(A2,B2)),IF(AND(B2<>"",B2<C2),B2,C2))	NETWORKDAYS formula only for column A and B
2	3/10/2021		3/13/2021	3	3
3	3/10/2021	3/11/2021	3/18/2021	1	2
4	3/10/2021	3/15/2021	3/10/2021	1	4
5	3/10/2021	3/17/2021	3/18/2021	1	6
Sheet1 (4)

Cell Formulas
Range	Formula
D2:D5	D2	=NETWORKDAYS(IF(B2>C2,A2,MAX(A2,B2)),IF(AND(B2<>"",B2<C2),B2,C2))
E2	E2	=NETWORKDAYS(A2,C2)
E3:E5	E3	=NETWORKDAYS(A3,B3)

 

[Fluff]

Ok, how about

=IF(AND(B2<C2,B2<>""),NETWORKDAYS(A2,B2),NETWORKDAYS(A2,C2))

 

[searchingforhelp]

Hi Fluff,

Thank you for volunteering to assist me with two complex formulas. These formulas will play a great role in what I am trying to accomplish. Without them, I would have defaulted to multiple small formulas in separate columns to complete a result. Please feel free to let me how you can receive recognition for assisting me.

Thank you.

Originally assigned

=IF(AND(B2<C2,B2<>""),NETWORKDAYS(A2,B2),NETWORKDAYS(A2,C2)

Assignment reassignments

=IF(OR(B2="",B2>C2),"not applicable",NETWORKDAYS(IF(B2>C2,A2,MAX(A2,B2)),C2))

Copy of Example 2.xlsx
	A	B	C	D	E
1	Date when Originally assigned	Date when assignment was reassigned	Date when assignment was completed	Originally assigned	Assignment Reassigned
2	3/10/2021		3/13/2021	3	not applicable
3	3/10/2021	3/11/2021	3/18/2021	2	6
4	3/10/2021	3/15/2021	3/10/2021	1	not applicable
5	3/10/2021	3/17/2021	3/18/2021	6	2
Working on

Cell Formulas
Range	Formula
D2:D5	D2	=IF(AND(B2<C2,B2<>""),NETWORKDAYS(A2,B2),NETWORKDAYS(A2,C2))
E2:E5	E2	=IF(OR(B2="",B2>C2),"not applicable",NETWORKDAYS(IF(B2>C2,A2,MAX(A2,B2)),C2))

 

[Fluff]

Glad to help & thanks for the feedback.

Please feel free to let me how you can receive recognition for assisting me.

You've already done that by letting us know it works.