Dear Martin,

what i want in Sheet 2 the output would be:
Sr No Date Occasion
1 01 January 2006 Sunday
2 07 January 2006 Saturday
3 08 January 2006 Sunday
4 14 January 2006 Saturday
5 15 January 2006 Sunday
6 21 January 2006 Saturday
7 22 January 2006 Sunday
8 26 January 2006 a
9 28 January 2006 Saturday
10 29 January 2006 Sunday

I hope i have given the reasonable example to make u understand whats
my requirement.

Just to


On Dec 13, 1:35 pm, Martin Fishlock
wrote:
Akash,

Please can you explain a little mmore with some examples of sheet two.

I can't work out what you want.

--
Hope this helps
Martin Fishlock
Please do not forget to rate this reply.

"Akash" wrote:
Hi,

Suppose in Sheet1 i have mentioned few days of holidays which company
provided us in the entre year:

S.No Occasion Date
1 a 26th Jan 2007
2 b 15th Aug 2007

and so on....

Now i want to macro which can give me the output in the Sheet2

counting all the Sundays & Saturday along with their Date including the
Dates mentioned in the Sheet1. & the the Date should get filtered in
the Assending order. 1st Jan then 2nd Feb, 3 March

Is this possible

Awaiting for your reply

Thanks

Akash