Thanks Etaf & Daddy for your quick reply.In other words ,Is it possible to find the first and last possible/available weekday of given data.Here in this example the recent completed whole week is between 4-feb-14 & 6-feb-14.Monday and friday are missing.I want the result to show that the first possible weekday = 4-feb-14
The last possible weekday = 6-feb-14.I think it is bit challenging.Can anybody help me to find a way out?Thanks in advance.


14-Jan-14
15-Jan-14
16-Jan-14
17-Jan-14
20-Jan-14
21-Jan-14
22-Jan-14
23-Jan-14
24-Jan-14
27-Jan-14
28-Jan-14
29-Jan-14
30-Jan-14
31-Jan-14

4-Feb-14
5-Feb-14
6-Feb-14

10-Feb-14
11-Feb-14



Regards,

Netaji