Excel Schedul Bulanan dengan Kondisi Khusus

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

1. The number of 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. Their can't perform their duties from Fri to Sun.

My Question is:

1. How to make automatic generated monthly schedule of person who incharge MOD with their special conditions?
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.

Di Lepi saya gak bisa dibuka tuh den, kenapa ya?

Aku pakai excel 2010, bisa dibuka di excel 2007. kamu pakai excel ver berapa?

masih pake yang 2003 den, berarti gak bisa dioperasikan di versi lama ya?

Kalo dipakai di 2003 ga bisa soalnya ada keterbatasan limit mengenai tingkatan rumus.... jadi kalo lebih dari 15 tingkat ga bisa... kalo ga salah 15 atau 20 tingkat gituloh.... hehehehehee

oh gitu wah mesti upgrade dulu nih.. nanti deh aku coba ya kayaknya xls nya berguna nih buat aku

Iya nich.... office 2003 sdh ketinggalan jauh.... dan banyak keterbatasannya... mending 2007 atau 2010 sekalian.