allow users to edit ranges

The attached file has been shared with my colluges, now they are having access to edit the ranges for all the dates and it was protected with unique password for each and every bay.

Some times they are editing the values for the completed dates, now i need to protect them for the dates which has been completed and they should be allowed only to modify the datas only for today and yesterday, for that i need vba prcedure to prevent the access.

Please help me to solve this issue, and many thanks in advance for all your efforts.

Thanks & Regards
Muralidaran.