Skip to main content

Task Due Dates Need to be Workday

  • December 6, 2018
  • 1 reply
  • 0 views

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

Forum|alt.badge.img+17
  • Inspiring
  • 183 replies
  • December 6, 2018

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


Reply