Automatic Scheduler

Hey all,

I've been working on an automatic scheduler in Excel off and on, and I just can't seem to get it to work. I end up doing a ridiculous number of nested ifs. I'm hoping you all could help.

So, a project is assigned on a specific date. That project also has a release date down the road. Here are some of the rules for the scheduler:

Note: Tasks are done once a week. Projects can be released any day of the week.

1. Once assigned, a project is "Built" that week (a week being Sunday-Sunday). That project is also updated the next week.
2. Projects are updated once every 4 weeks, unless the Sunday of this week is within 8 weeks of the release date.
-if within 8 weeks, the project is updated every week
3. Projects are updated until 2 weeks after release
4. If a new "asset" is released during this schedule, an update is required during the release of that update and the following week. After that, it resumes the ><8 week schedule.

Other things to note:
-release dates change and are sometimes not available

Basically, I'd like to have the layout be similar to a calendar. I've attached a sample worksheet. The new asset and release dates should be manually entered.

In the sample, these are the label definitions:

BLD=build
1UP=first update
WUP=weekly update (<=8 weeks release)
MUP=monthly update (>8 weeks release)
FUP=final update (2 weeks past release)
NEW=new asset
NUP=new asset update

Please let me know if you have any questions.