I have a select statement that currently works like below:
select inwp.cpp_quotation_days + cp.cp_date_created as [Date Quote Due]
cpp_quotation_days come from a table for this example lets say quotation days = 20
If i add 20 to the cp_date_created field I get the Date Quote Due.
A new requirement is for the calculation to only add working days to get the Date Quote Due (exluding weeknd and public holidays)