13 Replies Latest reply: Apr 24, 2015 4:54 AM by Ankita Agarwal RSS

    Date in Blocks

    Phil Speight

      Hi

       

      I have a list of absences that I want to report on.  Rather than show each date I want to show the date in blocks.  Please see my data below:

       

      Joe 01/04/14

      Joe 02/04/14

      Joe 03/04/14

      Joe 15/07/14

      Joe 16/07/14

      Joe 12/08/14

      Bill 01/07/14

      Bill 02/07/14

      Bill 20/11/14

      Bill 21/11/14

      Bill 15/12/15

       

       

      I want to output :

       

      Joe 01/04/14 - 03/04/14

      Joe 15/07/14 - 16/07/14

      Joe 12/08/14 - 12/08/14

       

      Bill 01/07/14 - 02/07/14

      Bill 20/11/14 - 21/11/14

      Bill 15/12/14 - 15/12/14

       

       

      Any thoughts?

       

       

      Thanks

       

       

      Phil