View Single Post
 
Old 10-21-2016, 02:06 PM
Mars Mars is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Oct 2016
Posts: 2
Mars is on a distinguished road
Question Counting How many Times a date appears between two ranges of dates

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.
Reply With Quote