3 Replies Latest reply on Feb 5, 2019 9:54 PM by Shinichiro Murakami

    Count no of Days

    Aman Singh

      Hi Team,

      hope you are doing well. I came with a problem and unable to find any solution. hope any one can help -

       

      I want output like this -

      WorkmenStart DateEnd DateNo of days work
      Aashish Kumar03/05/201805/05/2018

      2

      Aashish Kumar07/05/201805/15/20188

       

      If you see the attached workbook i have workmen and date column. I want no of days of work men for continuous date and non continuous date.

      Find start date and end date for continuous date and non continuous date.

       

      Please find attached workbook.

       

      Regards,

      Aman