Is there a way to include Saturday in work week?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered
Is there a way to include Saturday in my work week?  I have a start date, # of days allocated, finish date.  I would like for my finish date to skip Sundays (if the Work Week box is not checked) or include Saturdays (if the Work Week is Monday-Friday box is checked.
Photo of Lynne8817

Lynne8817

  • 600 Points 500 badge 2x thumb

Posted 4 years ago

  • 0
  • 1
Photo of Jack

Jack, Champion

  • 50 Points
I would suggest unticking the box which means all 7 days are counted. Then use a formula field (call it perhaps working days allocated, which you can hide) to calculate the number of Sundays then add this to the days allocated figure, which should then cause your date field to apply the correct date.

So for example (I have assumed your number of days field is a duration field rather than a numeric field with conversion).

Create a formula duration field (called working days allocated):

Days(Floor(ToNumber(ToText([# of working days]/7))/24))+[# of working days]

Then amend your finish date field to reference the working days allocated field, this should also work with half days or quarter days.