4 Replies Latest reply: Jun 19, 2013 6:16 AM by luis almoguera RSS

    Build an Incomes Calendar with Just Registration Date - End Date and Tariff.

    luis almoguera

      Hi guys,

       

      I am trying to find a solution for this issue:

       

      I just have this excel with this information:

       

      MEMBERREG DATETERM DATECUST TYPEENTRANCE FEEDAYLY FEE
      LUIS01/06/201312/06/2013110050
      PABLO05/06/201315/06/2013110050
      LUCAS08/05/20131100             50
      MARIA10/06/2013 2200100

       

      Where:

      Member > Guest

      Reg Date > Registration Date when the guest signs in.

      Ter Date > Termination Date when the guest signs out.

      Entrance Fee and dayly Fee.

       

      I want to track which are my incomes every day from the first date of Reg Date till today (when today is the day I reload the document).

       

      Something like this:

       

      MEMBER01/06/201302/06/201303/06/201304/06/201305/06/201306/06/201307/06/201308/06/201309/06/201310/06/201311/06/201312/06/201313/06/201314/06/201315/06/201316/06/201317/06/201318/06/2013
      LUIS1505050505050505050505050000000
      PABLO0000150150150150150150150150150150150000
      LUCAS000000015050505050505050505050
      MARIA000000000300100100100100100100100100

       

       

      If I reload the document the 05th of JulyI have to obtain the rest of the days automatically, so I can track my incomes by just using the first imput excel.

       

      Is there anyway I can achieve this?


      Thanks a lot in advance.

       

      PD. Excel attached.

       

      Regards