Need help with arrival, departure and date ranges

[katalyzt_94]

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?

 

[njimack]

This does what you're after, although I have a different result for 7th Jan:

Excel Workbook
	A	B	C	D	E	F	G	H
1	Header 1	Type 1	Arrive Date	Type 2	Depart date
2	Transaction 1	arrival	01/01/2015	departure	07/01/2015		01/01/2015	1
3	Transaction 2	arrival	02/01/2015	departure	05/01/2015		02/01/2015	2
4	Transaction 3	arrival	28/01/2015	departure	02/04/2015		03/01/2015	2
5	Transaction 4	Arrival	03/02/2015	departure	05/02/2015		04/01/2015	2
6							05/01/2015	1
7							06/01/2015	1
8							07/01/2015	0
Sheet1

 

[katalyzt_94]

Sorry for the late response. This worked PERFECT! Thank you for your help!