I need to create a Due Date field that excludes weekends. So if the [Contract Release Date] is 4-11-16, the [Due Date] would be 5-23-16, instead of 5-11-16.

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
Photo of Nichole

Nichole

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,664 Points 50k badge 2x thumb
No problem

Make a new formula date field like this

WeekdayAdd([MyDateField],0)


The WeekDayAdd function will advance the date by X Business days, so we will just advance by zero Business days.
Photo of Nichole

Nichole

  • 0 Points
Thank you!! Is there a way to make this field editable, so if we have a specific due date, we can enter it?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,664 Points 50k badge 2x thumb
If you want to add X business days to a date, use

WeekDayAdd([StartDate], 30) for a date 30 business days out.

if you want to be able to override make a new date field called [Due date override].  
Then have a due date field as formula of

If(not IsNull([Due Date Override], [Due Date Override], WeekDayAdd([Start Date],30))
Photo of Nichole

Nichole

  • 0 Points
You rock! Thank you so much!! One more question, I'm using the following formula, but receiving an Formula syntax error, (mismatched parentheses, missing quotes, or brackets) for the life of me I can't see what I'm missing.... :(

If(not IsNull([Due Date Override], [Due Date Override], WeekDayAdd([Contract Release Date],30))
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,664 Points 50k badge 2x thumb
Sorry, my mistake
If(not IsNull([Due Date Override]), [Due Date Override], WeekDayAdd([Contract Release Date],30))