Build an Incomes Calendar with Just Registration Date - End Date and Tariff.
Hi guys,
I am trying to find a solution for this issue:
I just have this excel with this information:
MEMBER
REG DATE
TERM DATE
CUST TYPE
ENTRANCE FEE
DAYLY FEE
LUIS
01/06/2013
12/06/2013
1
100
50
PABLO
05/06/2013
15/06/2013
1
100
50
LUCAS
08/05/2013
1
100
50
MARIA
10/06/2013
2
200
100
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:
MEMBER
01/06/2013
02/06/2013
03/06/2013
04/06/2013
05/06/2013
06/06/2013
07/06/2013
08/06/2013
09/06/2013
10/06/2013
11/06/2013
12/06/2013
13/06/2013
14/06/2013
15/06/2013
16/06/2013
17/06/2013
18/06/2013
LUIS
150
50
50
50
50
50
50
50
50
50
50
50
0
0
0
0
0
0
PABLO
0
0
0
0
150
150
150
150
150
150
150
150
150
150
150
0
0
0
LUCAS
0
0
0
0
0
0
0
150
50
50
50
50
50
50
50
50
50
50
MARIA
0
0
0
0
0
0
0
0
0
300
100
100
100
100
100
100
100
100
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.
