Excel Data. Macros

We will have several excel data bases. In the data there is a start date and end date in different cells "20/08/2013 - 13/09/2013" the date varies for each record. We need to generate the dates in between the the start date and end date and include the the new dates in the spreadsheet.

We will also have this to do but instead of days we will need to do it weekly.

We will be receiving files on a weekley basis so would like a program/macro that can be used.