Couting Open Cases in Data Set

Hello,


I have a large dataset that contains case numbers and both Open and closed dates for those cases.

My goal is to be able to select a date , preferably in a pivot table, and see how many cases were pending on that date. I am completley stumed on how to create this calculation.


My data set looks similar to the below.


Case Number Date Open Date Closed
60054254 10/31/2014 1/12/2015
60054666 11/19/2014 1/12/2015
60054856 11/26/2014 1/9/2015
60054891 12/1/2014 3/30/2015
60054926 12/2/2014 1/26/2015
60054944 12/2/2014 1/19/2015
60054948 12/2/2014 1/14/2015
60055072 12/9/2014 1/13/2015



Any help or insight would be greatly appriciated.

I think a pivot will help you to see what you need

Sorry! wasn't my intention. I am new here so I am trying to figure myself how I can solve my Excel problems.
I will take into consideration your reply and act accordingly.

Kr,
IonutC

create a new column on the left hand side say B
set aside a cell for the date of interest eg A1
set up a new column on the right hand side say F
in column F if the date in A1 is > then date open and less then date closed put a "Yes" in the column
If column F is "yes" increment column B - (if (f20 = "yes", max(b$1:b19)+1,"")
This will give you all the rows you want with an index number in column B
Set up a new tab with numbers 1 to xxx in column A and use vlookup to retrieve you results