Date list to complete date list showing no-event-dates

Hello,

I have a list of event days. This list does not show the dates where there are no events (travel dates, rest, holiday,...)
I want a complete chronological overview of all dates combined... the image explains it best... Scherm?afbeelding 2023-08-30 om 10.43.13.png
The green dates are missing in the initial list ... is it possible to create this in Excel? And can it be automated, so that I add a new event list that automatically is copied into a calendar or where the 'empty' dates are added...

Also attached an excel file

Warm regards,
Wim

Here is another solution for the whole date list in one go:

Formula:

Please Login or Register  to view this content.

See post #3

Another possibility would be to use Power Query. Most of the solution has been just "clicked in".

See the attached file and the code of the query is:

Please Login or Register  to view this content.

You are Welcome!

Thanks for the feedback and rep. . Glad to have helped.

Thanks for marking thread solved and for the reputation, as well as kind words