katalyzt_94
New Member
- Joined
- May 27, 2015
- Messages
- 2
Hello everyone,
I need help calculating total stays for a date range. I have several transactions that included an arrival and departure date and I need to figure out number of stays for each date. Example below
Transaction 1, arrival 1/1/2015, departure 1/7/2015
Transaction 2, arrival 1/2/2015, departure 1/5/2015
Transaction 3, arrival 1/28/2015, departure 2/4/2015
Transaction 4, Arrival 2/3/2015, departure 2/5/2015
I NEED TO FIGURE OUT THE NUMBER OF TRANSACATIONBS FOR DATE RANGE 1/1/2015-2/28/2015. The departure date should NOT be included on the date that it is listed.
1/1/2015 1
1/2/2015 2
1/3/2015 2
1/4/2015 2
1/5/2015 1
1/6/2015 1
1/7/2015 1
and so forth through the end of February. Is there a way I can calculate this using a formula?
I need help calculating total stays for a date range. I have several transactions that included an arrival and departure date and I need to figure out number of stays for each date. Example below
Transaction 1, arrival 1/1/2015, departure 1/7/2015
Transaction 2, arrival 1/2/2015, departure 1/5/2015
Transaction 3, arrival 1/28/2015, departure 2/4/2015
Transaction 4, Arrival 2/3/2015, departure 2/5/2015
I NEED TO FIGURE OUT THE NUMBER OF TRANSACATIONBS FOR DATE RANGE 1/1/2015-2/28/2015. The departure date should NOT be included on the date that it is listed.
1/1/2015 1
1/2/2015 2
1/3/2015 2
1/4/2015 2
1/5/2015 1
1/6/2015 1
1/7/2015 1
and so forth through the end of February. Is there a way I can calculate this using a formula?