Counting How many Times a date appears between two ranges of dates

[Mars]

I am working on a sheet for my boss due asap. I can't figure out how to get it to calculate though. I have:



Date In -- Date Out -- Date of
01/01/2016 -- 01/03/2016 -- 01/01/2016
01/02/2016 -- 01/03/2016 -- 01/02/2016
01/03/2016 -- 01/03/2016 -- 01/03/2016


I basically want to add a fourth column to show how many items/ persons where at x on the "Date of" so 01/01/2016 should be 1 ... 01/02/2016 should equal 2... and 01/03/2016 should be 3....

I have to do this with a years worth of information. Can someone please help me.

[Mars]

Never mind, though thanks for your time. I have figured it out... I made a simple error by crossing my "<" and ">" and now have my formula.