Copying 1 row with a date range to x rows with the individual dates

I have an Excel file containing data about employees. Each row contains a lot of information that is relevant for a specific date range, denoted by the columns "start date" and "end date". I would like to copy each row so that I have it accessible per date that is within the date range. The only columns that would change in the copy are the date columns. For example, for 1 row that has a date range of 01/08/2013 - 05/08/2013, I want to copy the row 5 times except the date columns become "01/08/2013", "02/08/2013", etc.

Is this at all possible in Excel?

Thanks

Ok, I uploaded an Excel file with a before and after tab. I constructed the "after" tab manually, this is the process that I would like to automate.