Add business days to a date based on logic (Conditional if then else)

Question

I need some help in adding the number of business days based on logic in Alteryx. I am not sure how to do it. I have thousands of rows with different values in the column Date and Type. If I use this logic below then it includes Saturdays and Sundays not sure how can I remove the weekends.

LOGIC: if !IsEmpty([Date]) and ([Type] = "IXRE" or IsEmpty([Type])) then DateTimeAdd([Date],15,"days") elseif !IsEmpty([Date]) and [Type] != "IXRE" then DateTimeAdd([Date],10,"days") else Null() endif

Sample data

DateType2021-05-24IXRE2021-05-25SAS-MXP2021-06-05

Any help is appreciated.

Thanks

Luke_C · Accepted Answer

Hi @manjarigoyal1975

Take a look at the solutions in these threads, I think both should get you going in the right direction

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Add-business-days-to-date/td-p/56743

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-add-business-days-to-the-date-field/td-p/414783