Hey guys,
I am trying to solve a problem which I have been stuck at for almost a week now, I am trying to create an annually planned schedule where I have 7 types of frequencies (Daily, Weekly, Biweekly, Monthly, Quarterly, 6 Monthly, Annually).
Each Task/Machinery requires a planned schedule and has a starting date as a base point to schedule the next appointment depending on the frequency inserted.
I have managed to solve daily, and weekly frequency's but I had no luck on solving other frequencies in a way where the cells start to populate beginning at the starting date, and automatically populate the upcoming date's respective cells depending on the frequency inserted (A week after "Weekly, A month later "Monthly", A 6 month later "6 Monthly".... etc).
Please find attached the excel file.
I am trying to solve a problem which I have been stuck at for almost a week now, I am trying to create an annually planned schedule where I have 7 types of frequencies (Daily, Weekly, Biweekly, Monthly, Quarterly, 6 Monthly, Annually).
Each Task/Machinery requires a planned schedule and has a starting date as a base point to schedule the next appointment depending on the frequency inserted.
I have managed to solve daily, and weekly frequency's but I had no luck on solving other frequencies in a way where the cells start to populate beginning at the starting date, and automatically populate the upcoming date's respective cells depending on the frequency inserted (A week after "Weekly, A month later "Monthly", A 6 month later "6 Monthly".... etc).
Please find attached the excel file.