Thanks Don.

Seems my requirement is sort of taken care by your formula. Thanks for that.

Can you explain how exactly the "lookup" and "weekday" functions work? That will help me in knowing these functions better.

Ravi.