AnsweredAssumed Answered

Weekday Date Calculation

Question asked by erinmgarcia on Nov 2, 2018
Latest reply on Nov 4, 2019 by WILLIAM51

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.