Subtract a number of working days from a date

Certified Senior Developer

Is there a function or expression to subtract a number of working days from a date?

caladddays does not accept a negative value and workday does not use the system working calendar so I was hoping there was a simple way to do this (if not I may have to write an expression rule that uses calworkdays and 'tries' several dates until it finds the correct one).

OriginalPostID-181852

OriginalPostID-181852

  Discussion posts and replies are publicly visible

Parents
  • Adding holidays to the calculation increases complexity, indeed. But then the calculation of the actual result depends on whether you want to move the date to before or after the holidays. You might have to do it in two steps. Get a first date using the workday() function. Now move back or forward until you find a valid date using the calisworkday() function.
Reply
  • Adding holidays to the calculation increases complexity, indeed. But then the calculation of the actual result depends on whether you want to move the date to before or after the holidays. You might have to do it in two steps. Get a first date using the workday() function. Now move back or forward until you find a valid date using the calisworkday() function.
Children
No Data