3 Replies Latest reply: Mar 4, 2016 6:12 AM by Sunny Talwar RSS

    How to segregate two continuous date into daily date

      Hi guys, I am new and having trouble when trying to execute this report. I got one excel file that have table as below,


      StartDateEndDateTypeOfLeave
      01/03/201501/03/2015Planned Leave
      06/04/201508/04/2015Planned Leave
      11/04/201512/04/2015Unplanned Leave

       

      and I want to segregate the startDate and EndDate into daily (Line by Line) like shown below,

       

      StartDateEndDateTypeOfLeave
      01/03/201501/03/2015Planned Leave
      06/04/201506/04/2015Planned Leave
      07/04/201507/04/2015Planned Leave
      08/04/201508/04/2015Planned Leave
      11/04/201511/04/2015Unplanned Leave
      12/04/201512/04/2015Unplanned Leave

       

      Please help me out because its very urgent.

       

      regards,

      Azieda