Multiple Criteria Date Formula

All,

I have been tasked to build a service schedule for the 2010 year; I have to enter in a 2010 date according to the following criteria:

- Date must be 24-28 weeks from the 2009 date
- 2010 date must occur on a preferred day ('PREF D 1' or 'PREF D 2')
- Must not occur on a blackout day (Saturday)
- An office ('OFC') cannot have two service calls on one day

I would like to insert a formula into the column in yellow that will populate with a date according to this criteria.

Thanks in advance
Nadir

I have created a function in this file. It needed a slight modification of the input of the days, so instead of "Sun", it should be entered 1, Mon=2, Tue=3, etc. Take a look and let me know any comments.

J.