I have a problem regarding the preparation of MOD schedules. Due to:

1. The number of MOD staff exceeds the number of days in that month.
2. There MOD officials who can not perform their duties on certain days such as Puji Ariyani and Suryanti.

My Question is:

1. How to make automatic generated monthly schedule of person who incharge MOD?
2. How to make the rest person to do the MOD in the next month automatically? Because in one month have 28 to 31 days but the person incharge more than 40 attendant.

Herewith I attach an example of data in question.
Thanks for your help.

Attached Files

WHOLE YEARS MOD SCH Testing.xlsx (30.7 KB, 24 views)

And your question is??

My Question is:

1. How to make automatic generated monthly schedule of person who incharge MOD?
2. How to make the rest person to do the MOD in the next month automatically? Because in one month have 28 to 31 days but the person incharge more than 40 attendant.

Thank you