Exclude saturday and sunday between 2 sum dates

codyt97 — Wed, 20 Oct 2021 16:36:33 GMT

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

Re: Exclude saturday and sunday between 2 sum dates

JGMDataAnalysis — Wed, 20 Oct 2021 18:37:12 GMT

Something like this...

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

topic Exclude saturday and sunday between 2 sum dates in Search the Community

Exclude saturday and sunday between 2 sum dates

Re: Exclude saturday and sunday between 2 sum dates