2 Replies Latest reply on Jul 13, 2018 7:03 AM by joy.delosreyes

    Estimating the working and days left

    sada.ambati

      Hi All,

       

      I have issue with dates calculations

      i have date like start date of project and due date project,so i need

      remaining days in month and Working days in month

       

       

      Out put like i have date as month

       

       

      Assignee    Month        days left       working days               %

             A           Jul 2018      17                     17                           100%        

          B           Jul 2018      17                     15                          85%       

          C           Jul 2018      17                     14                          80%  

              B           Aug2018        31                         20                             70%

               A           Aug2018        31                         25                             80%

                C           Aug2018        31                         22                             75%

              C           Sep2018         30                        20                               70% 

            B           Sep2018         30                        29                               99%

            A          Sep2018         30                        26                              85%  like that

       

       

       

       

       

       

      I Attache the data in tableau