I need help with a Macro for Excel

*I'm creating a safety calendar to make our lives a bit easier at work.

I wanted to use a Macro that reads entries in the circled yellow area (the calendar itself) and subsequently updates the date in "Safe days" (red arrow) using the date it's respective cell is put onto the calendar.

I also have a side request for help to make the calendar update daily with an increasing number depending on how many safe days we have in a row.

Ex:

Any ideas or advice are greatly appreciated!

If this is impossible, please also let me know.

And if more context is needed, I'll attempt to explain more.

Thanks in advance!