Well I'm back again. I am trying to produce a Automated Duty roster. It should have a list of name in one column and dates in the other columns. The duty day is determined by the number of personnel you have available and wether they are available for that day. I included a example of how it should look after calculating. The issue is that weekends and holidays need to be calculated independently. Each day has a value for the person as the days progress the value gets higher. When the value reaches 1 more then the amount of personnel a "X" replaces the number and the person has duty that day. after that day the their number starts at 1 again.
Bookmarks