Forum Discussion

AdamTanner's avatar
AdamTanner
Qrew Trainee
8 years ago

Duration formula that only counts business days

I am trying to come up with a formula to track an SLA and only count business days. Right now my formula looks like this : (ToDays([Date Created]-(If([Assigned]=false,Now())))*-1) Does anyone...
Formulas and functions
LeslieMeyer's avatar
LeslieMeyer
Qrew Member
8 years ago
Can you provide me with a variation on the formula above?  I need the max of the last two dates, and this formula attempt isn't right:  WeekdaySub([Date Completed], (max[Assigned Date],[Re-assignment Date]))
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
Can you post the error message or describe the problem with the result of your formula?

Are all the field involved date field types or are some of them a different field type such as date/time of text?