1. Put the start date in the cell where you want your first date to be. Let's put 6/1/14 as an example.
2. Select that Cell and in Home Tab, go to Fill and Select Series
3. Select Series in Columns if you want Column to be populated (Most likely case). Put End Date in in stop value as we want to generate dates till that end date and OK to generate list of numbers. Step value consists of increments by which dates have to be incremented. (If you want to space out dates with one week interval, put 7 in step value)