AnsweredAssumed Answered

Weekday Date Calculation

Question asked by erinmgarcia on Nov 2, 2018

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.

Outcomes