The DateAdd() was what I needed, and the weekday part is even better.  Thanks. 

RayM - the value for OPENDT? is the day the case was opened on the system and...