First let me appolozige for posting the code in a clumsy manner, though I tried creating spaces, it did end up like that after I posted it. Will try to be clear next time I post.

Sean Lange - Thank you!

Alan.B -- Thank you for both the codes, I like the one with days out & days in .

ScottPletcher -- Thanks a ton!!

dwain.c -- Thanks for the code, I was able to get the code till the first grouping you mentioned

, the commented portion of the code is where I am stuck.Thanks for the explanation.

For now I am going with Scott Pletcher's code.

Thank you all once again!!