Hi, I'm hoping someone can help me. I am trying to find a set of functions that will provide a serial counter based on dates (1=earliest date) between two date ranges. The dates are unsorted and also contain the same dates for several entries. I have attached a sample data to further explain my problem. The desired results are in Column A of the table. The date range to begin and end the serial counter is in B3 and C3. Column E are the dates which the function should look at. Can someone please help?

Sample_Data.xlsx