add 5 business days to date saved search

AI generated answer (using internal Slack threads):

To add 5 business days to a date in a saved search, you can use a formula similar to the ones discussed in the threads. However, please note that these formulas do not account for holidays, which may be considered non-business days in many contexts. Here's a formula that you can use:

CASE 
WHEN TO_CHAR({today}, 'DY') = 'MON' THEN {today} + 7
WHEN TO_CHAR({today}, 'DY') = 'TUE' THEN {today} + 7
WHEN TO_CHAR({today}, 'DY') = 'WED' THEN {today} + 7
WHEN TO_CHAR({today}, 'DY') = 'THU' THEN {today} + 9
WHEN TO_CHAR({today}, 'DY') = 'FRI' THEN {today} + 9
WHEN TO_CHAR({today}, 'DY') = 'SAT' THEN {today} + 8
WHEN TO_CHAR({today}, 'DY') = 'SUN' THEN {today} + 7
END

This formula checks the current day of the week and adds the appropriate number of days to reach the date that is 5 business days in the future. For example, if the current day is Monday, Tuesday, or Wednesday, it adds 7 days to the current date. If the current day is Thursday or Friday, it adds 9 days. If the current day is Saturday, it adds 8 days, and if it's Sunday, it adds 7 days. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******