Creating a calendar between 2 variable dates to a specific format

Hello all

I'd really appreciate your help. I have a database (attached) to which I would like to have a mini calendar included so that I can make notes as to what happened on certain days. My problem is that the number of days for each worksheet will vary. The startdate (B6) and the end date (B78) need to be included along with the day of the week underneath (that bit I can do!) and it needs to go along a row.
The idea of what I would like is shown in A36:D53. I would also like the formatting to be included (does not have to be those colours, just as long as you can see the text and they are different) Not asking much am I. I found something for autofilling in dates for a column but not for a row and I really do not have the knowledge to try to code this myself.

Thanks for your time

Helen