I am trying to calculate a due date either by adding business days (BD) or calendar days (CD). This formula works when the days in the Offset column is positive but if the Offset column is a negative number then it doesn’t work. Any idea on how to get it to work for negative numbers?
FORMAT_DATE(IF({Cadence}=“BD”,WORKDAY({Beginning Date},{Offset}),IF({Cadence}=“CD”,ADD_DAYS({Beginning Date},{Offset},“”))),“dddd, MMMM Do YYYY”)
