Here's a scheduling workbook that I'd definitely like help with--how to auto update dates in a column based on a number of days in another column and conditions in columns on another sheet.

Here’s the Setup:
There are numerous sheets for numerous school classes and the sheets are named like this: CG-world history, CG-pre-algebra, CG-music, etc. The prefix CG stands for curriculum guide. Each sheet is basically a listing of all the daily lessons for the course.

In each sheet, the starting date of a quarter or term will be entered in some cell at the top, such as C2. In the attached example, the main heading row is row 6, although the number of rows above the main heading row for each class will vary.

Column C will be a date column. Users will enter the starting date of a lesson col C, starting under a heading labeled "Date of Lesson".

The previous column, col B, will have a heading named "Required # of Days" which is the number of days suggested or needed to complete the lesson.

Desired Functionality
**Alternative to entering dates in col C, teachers could simply enter a number of days needed to complete a lesson, such as 2, in col B, and the date in col C will be auto filled or auto updated based on the date in the previous row plus the number entered in col B.

**When a number of days needed for a lesson, such as 2, is entered in any row that already has a date in col C, update any dates entered in the rows below that also have a number of days entered in col B. If any of the below dates would fall on a Saturday or Sunday, then advance the date to the following Monday--and update all other dates accordingly.

**Also have this do one other check--have it look at a sheet named Calendar that has columns named Date, Event, In Session, and Grade Level. In the col named "In Session", if there is a "Y" for yes, that means school is in-session and lessons would be taught as scheduled. If there is an "N" for some calendar event causing classes to be out for one or more grades delimited by commas in col D, then (for CG sheets with affected grade levels in col A) advance the conflicting date on the CG sheet to the following school day, and all other dates accordingly (if it pushes into a Saturday, have it jump to Monday).

I know this seems like a lot, and probably is, but this would help teachers at my school and may help other schools in lesson planning.

Thanks for any consideration and help in programming.
CURRICULUM GUIDE.xlsx