Exploding out rows depending on dates

Lets say we have 3 columns of data.

A: contains a unique reference
B: contains a start date
C: contains an end date, in some cases the end date is blank.

What I would like to do is explode the data out to show a link for each date.

So for example:
A1 10/1/2017 13/1/2017
A2 12/1/2017 12/1/2017
A3 14/1/2017 16/1/2017
A4 10/1/2017 NULL

So the output would be:

A1 10/1/2017
A1 11/1/2017
A1 12/1/2017
A1 13/1/2017
A2 12/1/2017
A3 14/1/2017
A3 15/1/2017
A3 16/1/2017
A4 10/1/2017
A4 11/1/2017
A4 12/1/2017
A4 13/1/2017
A4 14/1/2017
A4 15/1/2017

Thank you. Lucy
A4 16/1/2017

Hi everyone, is this possible ? Thanks in advance.

See attached file.
Hope this helps.

Hhi Modytrane, thanks for your reply but I was hoping to achieve this using a macro as the dates will change, I think you've just copied my output above into Excel (unless I am missing something).

Thanks again.

Try this:

Please Login or Register  to view this content.

Thanks MGS72, that is great.

My solution was based on formulas only and it would work when you change dates. Of course, Macro solution is better since it gives you more flexibility.
I wanted to show you how it could be done with formulas as well.

Hi Modytrane, I didn't even notice the formulas, my bad - i must apologise. I will take a look again.
Thanks