Formula Problem

[Richard Bleier]

I am trying to create a scheduling formula which alerts me if there are
scheduling conflicts. I have 4 different dates which a 5th date cannot
match. In addition, it cannot conflict with the 4th date and including 35
days prior. For example:

B2 = Inventory Date (cannot conflict with this date and 35 days prior)
C2 = Reset 1 Date - (cannot match this date)
D2 = Reset 2 Date - (cannot match this date)
E2 = Reset 3 Date - (cannot match this date).

The formula I have is:
=IF(F2="","",IF(F2=C2,"Reset 1 Conflict",IF(F2=D2,"Reset 2
Conflict",IF(F2=E2,"Reset 3 Conflict",IF(F2=B2,"Inventory
Conflict",IF(B2-35<F2,"Inventory Conflict","No Conflict"))))))

This covers all criteria I need except: It flags all dates after the
inventory date as an "Inventory Conflict". The only dates it should flag
after this date are if they match Reset 1, 2 or 3. I need to eliminate the
"Inventory Conflict" flag after the B2 (Inventory) Date unless they match
C2, D2, or E2.

Thanks

 

[Dave Peterson]

Richard got a reply that worked at a later post.

(from Allan S. Warrior)

 

[Sandy Mann]

Richard got a reply that worked at a later post.

(from Allan S. Warrior)

Now he tells me! <g>

Sandy