1 Reply Latest reply on May 7, 2012 4:00 PM by philmodjunk

    Need Date Calculation for counting Week Days Only

    lbellino

      Title

      Need Date Calculation for counting Week Days Only

      Post

      I currently created a calculation field that will calculate the time lapsed between when something was created and it was completed. Is there a way to revise this calculation where it will only count weekdays and not the weekends? Image shows what I currently have in the calculation field where it's counting all the days.

      DateCalculation2.PNG

        • 1. Re: Need Date Calculation for counting Week Days Only
          philmodjunk

          There are several approaches different folks have created for this. One can be found if you use the KnowledgeBase link at the top of this screen and search out the correct article.

          A key detail to consider however, is whether you want all week days or do you need to adjust your calculation to allow for holidays that might fall in the date interval. If so, you'll also need to consider how you would record the list of such holiday dates in your database so that you can adjust your count for them.