Userform auto fill dates in between

Hello!
I am new to this with posting in forums, but I have got stuck right now.
I have this Userform with alot of datepickers, these are for different periods.

But i Want them to autofill the dates in between the dates I have choosen and transfer to the sheet example cell A1.
I have tried so many different programing codes but not even got close. Is there some VBA encoding that can do this for me.?

I am very greatful for the help, I have attached the file with the Userform (click the "button").

Kindregards
Henrik

Just into the sheet example "Sheet1" and into cell A1. It does not matter so much , what i am really seeking is if it is possible to fill in the "gaps" between the dates and transfer...
many many thanks for you looking into this " Norie"

Dear Norie!
When I have filled in the first dates example 1 of May to 14 of May (dtpicker 1 and 2) then I would like the dtpicker 3 and 4 continue on next available row (15 of may to 12 of June for example), so the dates stay together..

My god you are a genius!! Many many thanks "Norie" it works. I never thought it could do so complex things! THANK you so much!
I actually have one more not in another workbook, if you could "work" your mastermind?!
Once again many thanks!

Hi Hep

One way will be to insert all the dates that you need (Quick tip, go to the last date that you have, Highlight as many cells as you want to fill and press Alt + E, then i then s. All your dates will be entered.)

Then in B16 enter

Please Login or Register  to view this content.

Copy and paste down to the end of your dates (Quick tip - Hover over the lower right corner of B16 until your cursor is a +. Double click. This will send the formula down to the bottom of your data.

Job done

Regards
Alastair