Help

Task Due Dates Need to be Workday

1631 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Annette_Neff
4 - Data Explorer
4 - Data Explorer

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!

1 Reply 1

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