Excel Macro for Cleaning Scheduler with rules

I have a cleaning schedule for 4 types of different cleaning to be performed on Quarterly, monthly, weekly, daily basis. There are some rules which will need to be in place. - Clean interval to be done within the stipulated period with respect to the clean type: > Quarterly Once every 4 months > Monthly: Once every month > Weekly: Once a week > Daily: Every day - Cleaning hierarchy (Quarterly>Monthly>weekly>daily): E.g: If monthly cleaning takes place on the week of 16Mar22, then weekly clean for the week of 16Mar is not required. Daily clean on 16Mar is also not required. If weekly clean takes place on 22Mar22., then daily clean on 22Mar is not required. The cleaning schedule date changes quite often due to requested impromptu cleans. Hecne, the schedule needs to update for future schedule per the rules whenever the cleaner inputs a new clean date. This is to avoid missing out cleans and performing the right clean per the hierarchy above. I have an excel template and will share the details through a zoom call. I believe this should be an easy task and expect the date of completion to be within 1-2 weeks. Will release payment after testing the macro. I also expect the VBA code to have comments/descriptions of the functions introduced.