Auto Assigned Due Date to Writers, Weekdays Only

Topic Labels: Formulas
633 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hi, I’d like to auto-assign due dates to our writers. However, there are some conditions:

  1. I don’t want due dates to ever occur on weekends
  2. Some writers work 3 days a week (M,W,F) and some 5 days a week.

Is there a formula I can use to do this and all the while include the start date for the first assigned task?

0 Replies 0