If Function Turnaround Time

[tcopeland]

I am hoping someone can help me, I have been trying to create a formula that would let our department track turnaround times. When I try Networkdays I get 1 on a same day turnaround. I fixed that by adding -1 to the formula. Now, I am trying to create either a If or Countif function - I don't know which would be better, and none that I have tried are able to return the right Turnaround time if the original request is not correct.

What I would like help with is a formula that if the Initial Request is Correct - "y" the Date of of the Initial Request is used as the start date and if the Initial Request is not correct "N" the Date of the Corrected Request is used as the start date.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Date of Initial Request[/TD]
[TD]Initial Request Correct[/TD]
[TD]Date of Corrected Request[/TD]
[TD]Date Fulfilled[/TD]
[TD]Turnaround Time[/TD]
[/TR]
[TR]
[TD]6/3/19[/TD]
[TD]N[/TD]
[TD]6/4/19[/TD]
[TD]6/4/19[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Thanks,

LuAnn

 

[jtakw]

Hi,

Is this what you mean:

Book1
	A	B	C	D	E
1	Date of Initial Request	Initial Request Correct	Date of Corrected Request	Date Fulfilled	Turnaround Time
2	6/3/2019	N	6/4/2019	6/4/2019	0
3	6/3/2019	Y	6/4/2019	6/4/2019	1
Sheet669

Cell Formulas
Range	Formula
E2	=NETWORKDAYS(IF(B2="Y",A2,C2),D2)-1

 

[Ronanm]

Scrap my answer

 

[tcopeland]

Thank you!!!! That worked. I really apprecaite your quick and easy response. - I was able to translate to my Smartsheet workbork and it worked perfectly.

 

[jtakw]

You're welcome.