Hello,
I have a situation where I have to schedule Dr. appointments on every Tuesday and Thursday of each month. There are 2 offices that get scheduled (room 101 and room 505). We can only schedule 1 appointment per day per office. I have 2 columns that have the Tuesday and Thursday dates before the appointment day and 2 other columns that have the Tuesday and Thursday date after the appoint day.
The appointments are scheduled 365 days after the last appointment so there are several appointment dates that fall on the same Tuesday or Thursday. I can only schedule 2 appointments per day on a Tuesday or Thursday. I do not have more than 6 appointments at one time fall on that same day. I need to figure out how to schedule the appointments for room 101 and 505 and not have duplicate dates. Can anyone help figure this out?
thank you
here is a small sample of my table
<tbody>
</tbody>
I have a situation where I have to schedule Dr. appointments on every Tuesday and Thursday of each month. There are 2 offices that get scheduled (room 101 and room 505). We can only schedule 1 appointment per day per office. I have 2 columns that have the Tuesday and Thursday dates before the appointment day and 2 other columns that have the Tuesday and Thursday date after the appoint day.
The appointments are scheduled 365 days after the last appointment so there are several appointment dates that fall on the same Tuesday or Thursday. I can only schedule 2 appointments per day on a Tuesday or Thursday. I do not have more than 6 appointments at one time fall on that same day. I need to figure out how to schedule the appointments for room 101 and 505 and not have duplicate dates. Can anyone help figure this out?
thank you
here is a small sample of my table
| appointment date | Tuesdsay before | Thursday before | Tuesday after | Thursday after |
| 1/4/2016 | 12/29/2015 | 12/31/2015 | 1/5/2016 | 1/7/2016 |
| 11/22/2016 | 11/15/2016 | 11/17/2016 | 11/22/2016 | 11/24/2016 |
| 11/21/2016 | 11/15/2016 | 11/17/2016 | 11/22/2016 | 11/24/2016 |
| 11/20/2016 | 11/15/2016 | 11/17/2016 | 11/22/2016 | 11/24/2016 |
| 11/20/2016 | 11/15/2016 | 11/17/2016 | 11/22/2016 | 11/24/2016 |
<tbody>
</tbody>
