Is it possible that after clicking on a macro button taht does lot of other
work in a sheet - a prompt box or wateva shud ask me to pick from list the
weekdays . say the box should contain a list with ranges like
31-Dec-207 to 4-Jan-2008
7-Jan-2008 to 11-Jan-2008
...
and this range of working days should be till 29-Dec-2008 to 2-Jan-2009

So when i pick one of teh above range , the five days in a week shud
distribute in 5 columns say D3,E3,F3,G3,H3 and the ranges include only mon to
friday dates and do not include sat and sunday. so whteversystem date im in
now , when i picjk from the list i shud get the dates corresponding to teh
range only in those 5 columns... pls help