COUNTIF Date Falls within Date Range

[DaVinciDecoder]

Hi,

I'm attempting to count records at a specific MM/YYYY that fall within a date range that is organized into two columns, Start Date and End Date. Below, are a few examples:

Unique ID Start Date End Date
12345 6/1/2014 3/1/2015
54321 2/1/2014 5/1/2014
67890 6/1/2015 3/1/2017
09876 1/1/2014 3/1/2017

My summary page should look like the following:
Jan-14 Feb-14 Mar-14 Apr-14 May-14 June-14
1 2 2 2 2 3

Effectively, I'm trying to understand how many customers we had at a point in time. Thank you for the help.

 

[DaVinciDecoder]

The formatting is distorted in the post. Here's a vertical summary.
Jan-14 1
Feb-14 2
Mar-14 2
Apr-14 2
May-14 2
Jun-14 3

 

[Joe4]

I think you have an error in your expected output (based on your data sample). I only see 2 records for Jun-14.

So, let' say that your data is on a Sheet called "Data", and the dates are in columns B and C.
Let's say that your summary is on a Sheet called "Summary", and data start on row 2.
In cell A2, enter the date 1/1/2014, 2/1/2014 in cell A3, etc. Then format column A as "mmm-yy".
Now, in cell B2, enter this formula and copy down for all rows:

=COUNTIFS(Data!B:B,"<=" & A2,Data!C:C,">=" & A2)

That should give you what you want.

 

[DaVinciDecoder]

This works perfectly! My Countifs formula looked like the following prior to your recommendation: =COUNTIFS(Data!B:B, ">="&A2, Data!C:C, "<="&A2); I now see why it wasn't returning the desired output. I appreciate your help and you're correct Jun-14 should only have 2 records.

 

[Joe4]

You are welcome. Glad it all worked out.