Task Due Dates Need to be Workday


Hello All, I’ve set up a task table where I configure my due date using a Start Date field and a Task Length field using an Integer. I would like the resulting due dates to fall on weekdays only, preferably subtracting days so the due date falls on a Friday.

I’ve tried incorporating the WEEKDAY function, but it’s not working. Any help would be appreciated!


Sounds like the WORKDAY function should work for you:
WORKDAY({Start Date},{Task Length},[comma-separated list of holidays, not including weekends])