ContributionsMost RecentMost LikesSolutionsRe: Calculating SLA Start DateThank 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!Re: Calculating SLA Start DateI keep getting an formula syntax error. The following is the formula. if(ToTimeOfDay([Order Date]))<ToTimeOfDay("12 PM"),ToDate([Order Date]),WeekdayAdd(ToDate([Order Date]),3))Re: Calculating SLA Start Date i have my field set up with Date and Time, will this work or is better to add the time stamp field? Re: Calculating SLA Start Dateyes, it is an existing field. This will be my start date to determine my 3 day SLA, I need to be able to convert the Date, time stamp to just a date. make sense? For example: 1-5-17 11:05 AM wouldconvert to 1-5-17 or 1-5-17 12:05 pm would convert to 1-8-17 for start date. Need to convert time stamp to single day, excluding weekends and some holidays.Calculating SLA Start DateI am tracking SLA in my app, my problem is my start date needs to be figured by a time stamp and exclude weekends and holidays. For example: If the time stamp is before 12:00 PM it is the same day, after 12:00 pm start date should be next business day. Help! I feel that this should be a pretty easy formula butI have totally confused myselfover the last two days.