Exclude saturday and sunday between 2 sum dates

[codyt97]

Hey all.

I need help with a formula. I have an excel sheet that have every state with transit time.(I've attach the excel sheet below). From other side I have  a ship date in date format. I've managed to sum dates and exclude saturday and sunday if  ship date(TranDate) +  ground date = saturday or sunday. This is the formula below:

=Date(if(WeekDay(TranDate + "Ground date") = 'Sat', date(TranDate + [Ground date] + 2), if(WeekDay(TranDate + "Ground date") = 'Sun', date( TranDate + [Ground date] + 1), date(( TranDate + [Ground date]))))).

I need help to exclude weekend dates between TranDate and Ground date. Example 

Order H208222 have ship date(TranDate field) for 11/4 to California  and have ground date   4 days. 11/4 is a Thursday, so 4 business days should mean delivery date of 11/10, not 11/8.

Thank you in advance,

Cody

[JGMDataAnalysis]

Something like this...

Date(
	 [TranDate]
     + [Ground date]
     + NetWorkDays([TranDate] + 1, [TranDate] + [Ground date])
) AS [ResultDate]