I'm using a COUNTIFS, but my results are zero.
B2 formula: =COUNTIFS(C$2:C$50,"<="&A2,D$2:D$50,">="&A2)



Date Arrivals Last Night
12/31/2016 0 11/30/2016 12/31/2016
1/1/2017 0 12/1/2016 12/31/2016
1/2/2017 0 12/1/2016 12/31/2016
1/3/2017 0 12/1/2016 12/31/2016
1/4/2017 0 12/1/2016 12/31/2016
1/5/2017 0 12/1/2016 12/31/2016
1/6/2017 0 12/1/2016 12/31/2016
1/7/2017 0 12/1/2016 12/31/2016
1/8/2017 0 12/1/2016 12/31/2016
1/9/2017 0 12/1/2016 12/31/2016
1/10/2017 0 12/1/2016 12/31/2016
1/11/2017 0 12/1/2016 12/31/2016
1/12/2017 0 12/1/2016 12/31/2016
1/13/2017 0 12/1/2016 12/31/2016
1/14/2017 0 12/1/2016 12/31/2016
1/15/2017 0 12/1/2016 12/31/2016
1/16/2017 0 12/1/2016 12/31/2016
1/17/2017 0 12/1/2016 12/31/2016
1/18/2017 0 12/22/2016 12/31/2016
1/19/2017 0 12/25/2016 12/31/2016
1/20/2017 0 12/26/2016 1/1/2017
1/21/2017 0 12/26/2016 1/1/2017
1/22/2017 0 12/26/2016 1/1/2017
1/23/2017 0 12/28/2016 12/31/2016
1/24/2017 0 12/28/2016 12/31/2016
1/25/2017 0 12/28/2016 12/31/2016
1/26/2017 0 12/29/2016 12/31/2016
1/27/2017 0 12/29/2016 12/31/2016
1/28/2017 0 12/29/2016 1/1/2017
1/29/2017 0 12/29/2016 1/31/2017
1/30/2017 0 12/30/2016 12/31/2016
1/31/2017 0 12/30/2016 12/31/2016
2/1/2017 0 12/30/2016 12/31/2016
2/2/2017 0 12/30/2016 12/31/2016
2/3/2017 0 12/30/2016 1/1/2017