I would like some help on a small project.

I would like the user to enter 12 dates. Each pair of dates defines the
beginning and the end of a period. There are obviously six periods.

The difficult bit is this. I would like Excel to generate all the dates of
the 6 periods. They have to be next to each other AND with weekdays only.

I know I can do this with Fill, but I would like to automated it. Thank you
in advance.