4 Replies Latest reply on May 8, 2018 5:20 AM by Tim Dines

    Business Days in Month Calc

    Vikash Karra

      hey there - hoping someone can assist! Example: if today is april 29th, then i need to have a calculation that indicates that 20 Business Days have elapsed. 20 is calculated by the count of weekdays thru apr 29th (obviously, on apr 30th, that # would be 21). The remaining calculation would be for Business Days remaining. This should return 1 ((obviuously on Apr 30th, that # would be 0).

       

      So basically need the # of weekdays in a month (a fixed calculation i imagine)

      and then need to get the # of business days remaining (if it's past months, then that would be 0, but if it's a current month, then there should be a value returned). HOpe this makes sense!