Task Due Dates Need to be Workday


#1

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!


#2

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