CarolMcconnell

3 years agoQrew Captain

# Formula to find weekdays for a duration

I have this formula but I'm getting errors. I'm not sure if it's just a syntax issue or something else. If (IsNull ([Date Closed]),WeekdaySub(Today()-[NWS Date Received]-[Total pending First Open...

- 3 years agook, try this

// first calculate the End Date and put it into the formula variable called End Date

var date EndDate = IF(IsNull ([Date Closed]),Today(), [Date Closed]); // ok so now we know the End Date

WeekdaySub($EndDate, [NWS Date Received]) -ToDays([Total pending First Open])

------------------------------

Mark Shnier (YQC)

mark.shnier@gmail.com

------------------------------