Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Something like this...
Date(
[TranDate]
+ [Ground date]
+ NetWorkDays([TranDate] + 1, [TranDate] + [Ground date])
) AS [ResultDate]