Thank you! Got this to work. Now i need help with excluding Holidays. Below is the formula to determine my SLA start date, now i need to exclude the Holidays.
If(ToTimeOfDay([Order Date])<ToTimeOfDay("12 PM"),ToDate([Order Date]),WeekdayAdd(ToDate([Order Date]),1))
I have added an additional table with holiday dates, below is the formula that i have for the date
If([SLA Start Date]<=(ToDate("January 01,2018"))and[Ship Date]>=(ToDate("January 01,2018")),1)
then i combined all holidays to below
Sum(0,[New Year's Day],[Memorial Day],[Independence Day],[Labor Day],[Thanksgiving Day 1],[Thanksgiving Day 2],[Christmas Day 1],[Christmas Day 2])
I cannot figure out the best way incorporate into the first formula, HELP!