thanks laurie,

but this one also gives like:

date day week

1-Apr-2011 Friday 1

2-Apr-2011 Saturday 1

3-Apr-2011 Sunday 1

4-Apr-2011 Monday 1

5-Apr-2011 Tuesday 1

6-Apr-2011 Wednesday 1

7-Apr-2011 Thursday 1

8-Apr-2011 Friday 2

But i want like...

date day week

1-Apr-2011 Friday 1

2-Apr-2011 Saturday 1

3-Apr-2011 Sunday 2

4-Apr-2011 Monday 2

5-Apr-2011 Tuesday 2