Counting and specifying dates that fall within a predetermined range

Hello,

I have a table of dates corresponding to a certain ID. Each ID has a start date and an end date associated with it, and I need only the dates that fall within that start and end. An example of what a small part of my table would look like is the following:

example excel table.png

(I have attached the excel document in case you are unable to view images)

Example Excel Table.xlsx

I need a formula that I can then apply to a large amount of data in order to know the number of events falling into the specified date range for each ID, and the earliest date that falls into the specified range.

Thank you for your help!
Devin