Forum Discussion

CarolMcconnell's avatar
CarolMcconnell
Qrew Captain
3 years ago

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...
  • MarkShnier__You's avatar
    MarkShnier__You
    3 years ago
    ok, 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
    ------------------------------