Hello All

I need to create a dynamic range for a Combo Box.The dynamic range will be for a series of dates.I need the date sequence to be always 7 days before todays date and 7 days after todays date.eg...using todays date as 21/7/2013 the list dates will start with 14/7/2013 and end with 28/7/2013...it will also need to update daily so as there is always 7 days before and after todays date

If this is possible a excel file of how to achieve could it be posted please

Best Regards

Paul