Milestone Dashboard Calendar

Hi
I’m trying to prepare an automatic milestone dashboard and need some help. The attached spreadsheet has two tabs
1. Masterdata (source data getting updated every week)
2. Dashboard (populating data based on Masterdata)

Dashboard has calendar type view having week ending details. However the masterdata has two milestone date columns which are in date format (not weekending) The purpose is to check if Actual target date (in Masterdata tab) has slipped from Baseline target date for a milestone for a given project. This means if difference between these two dates is 0 then corresponding dashboard cell is Green else Red. I’ve done one color coding manually for P001. It will help you to understand what I am actually trying to implement. I’m trying to build a macro code, so that every week I can run the macro and update the dashboard.

Please note, one project might have more than one milestone but no two milestones will fall within same week. So all milestone will come under one line in the dashboard.

Any help will be highly appreciated. If the given dashboard format is impossible to implement you can restructure it and then come up with a solution. This dashboard format is just a prototype.