10 Replies Latest reply on Mar 29, 2013 8:21 AM by Lori Smith

    Would it be possible to get count of weekdays between two dates

    Joe Mako

      I am thinking something similar to Excel's http://office.microsoft.com/en-us/excel/HP052091901033.aspx

      NETWORKDAYS(start_date,end_date,holidays)
      function.

       

      I suppose currently the best way is to reshape it from:

       

       

      Project ID, Start date of project, End date of project
      
       1, 10/01/2008, 3/01/2009
      


       

      to

       

       

      Project ID, Date
      
       1, 10/01/2008
      1, 10/02/2008
      1, 10/03/2008
      ...
      1, 2/27/2009
      1, 2/28/2009
      1, 3/01/2009
      


       

      The downside is I just turned one row of data into more than a hundred. This can easily turn a few thousand rows into over a million rows.

       

      The upsides, I can create a calc field with my custom holidays to add the ability to filter out holidays, and get a count of active projects on each day.

       

      Are there any other options out there?