Task Calendar Trouble
I need to set up a monthly task calendar. Easy part. I'm setting up the calendar so that each day of the month, excel picks one random task, out of ten, for my employees to perform. The trouble I'm having is setting parameters. 1) no task performed 2 days in a row. 2) no task performed twice in one week 3) all tasks performed twice a month, where most will be performed three times in one month. 4) the tasks not performed three times in one month, due to short month, will be performed three times the following month. Can anyone help? Thanks