Is there a way to calculate a date that only includes weekdays, excluding weekend days? More specifically- I have a 'days to comply' field that has the options: 5, 15, 30. I'm using the equation now() + ${DaysToComply}*24*60*60*1000 to calculate the date, which works, but I don't want the calculation to include or date to fall on a weekend (or preferably holiday as well!). ie: today is Friday +5 would be Weds but SHOULD be Friday ie: today is Tuesday +5 would be Sunday but SHOULD be Tuesday Would like something similar to the workday function from excel. Workaround: changed calc options to include weekend days, 5=7, 15=21, 30=42 However, this does not account for holidays.
... View more