List All Dates Between Two Dates In Excel

I am trying to get a column of dates between two dates. Every date outside of the date range, I do not want to be shown in the column.

Start Date (E4) 9/1/19
End Date (H4) 9/15/19

My column/cells for the dates (A8) - (A24)

I want (A8) to show the date 9/1/19, (A9) 9/2/19, (A10) 9/3/19 etc. to (A21) 9/15/19.

Then (A23-A24) to be blank because they are outside of the End Date in (H4).

With the formula I am using, it does not stop showing dates outside of the end date.

So this is the formula I am using:

Please Login or Register  to view this content.

This is working on adding the dates. The problem I am having is that Cell (A23) & (A24) is showing the dates outside of the end date. So after 9/15/19 the other cells (A23) & (A24) should remain blank.

I am not sure why it is adding the other dates when I say

Please Login or Register  to view this content.

Can someone please help. Thanks

That does work with the date of 9/1/19 - 9/15/19. However when I change the date to 9/16/19 - 9/30/19. Then I get the same problem to where it shows 10/1/19 & 10/2/19. Which I do not want it to show as it is outside of the end date.

These dates will change depending on different factors. As an example:

Start -- End
1/1/19 -- 1/15/19
1/16/19 -- 1/31/19
2/1/19 -- 2/15/19
2/16/19 -- 2/28/19
3/1/19 -- 3/15/19
3/16/19 -- 3/31/19
etc
etc

Sadly that did not do the trick.

I found the problem. That did work. I just had mistyped the end date.

Thanks for your help and time. God Bless you.