in a column i need to have a drop down list which has dates from 31-01-2007
to 04-01-2008 , 07-01-2008 to 11-01-2008 etc (the week begins from monday to
friday) the concept here is that i should have only 5 working days of a week
and the list should contain all such weeks for the year so taht when i
select a particular range i shud get corresponding data fo rthat week.

The list entries shud be of teh format 31-Dec-2008 to 4-Jan-2008 likewise....
So when this entry is selected from the drop down list i should get the 5
days between this range in 5 columns say column A1,A2,A3,A4,A5
so when 07-Jan-2008 to 11-Jan-2008 is selected i shud get dates from 7th
to 11th in the same A1 column to A5