View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Akash Akash is offline
external usenet poster
 
Posts: 125
Default Tacking All Sunday & Saturday in a Year along with the dates

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