There is currently a function available in Forms to allow setting a "due date" based on an initial date that excludes holidays and weekends (AddDaysFromNumberColumnToDateColumnValue). I would like to be able to subtract days (or use a negative days value) to set "Task Due Dates". For example, if there is an upcoming event, we would enter the Event Date and then the dates for pre-check tasks for that event would be calculated as 15 days prior to event, 20 days prior to event, etc.
There is currently a function available in Forms to allow setting a "due date" based on an initial date that excludes holidays and weekends (AddDaysFromNumberColumnToDateColumnValue). I would like to be able to subtract days (or use a negative days value) to set "Task Due Dates". For example, if there is an upcoming event, we would enter the Event Date and then the dates for pre-check tasks for that event would be calculated as 15 days prior to event, 20 days prior to event, etc.
julie.stiles@fcso.com has reacted to this post.
