Populate cells if there is a MIN & MAX value

If I have a staff member that takes leave from 4-01-2014 to and including the 15-01-2014, is there any way I can
populate the 2 mentioned cells and the cells in between. I have attached an example spreadsheet - Sheet 1 contains the Staff
Member's name, the date they have chosen to start their leave and the date they wish to finish. On sheet 2 I have manually filled in
each day the staff member will be on leave. I'm just wondering if there is a way Excel will automatically fill in the fields for me. This
will help me in completing other stages of my Staff spreadsheet. Thank you for any assistance you can offer.