Spreadsheet: 453665d1459405544-automatically-put-in-10-black-cells-date-example
Sheet: Sheet1

 |  |  | 2014-08-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-08-17 00:00:00
 |  |  | 2014-08-25 00:00:00 | I want to copy the 17/08/2014 into the next 10 cells underneath before 25/08/2014 then do the same for the 25/08/2014. and so forth for the next date which would be 13/09/2014 I would like to then when I need to change the 10 to 16 when needed - this is only an example -                <----------Before                                                                     After----------------> This Sheet has 6000 entries |  |  |  |  |  |  |  |  |  |  | 2014-08-17 00:00:00
 |  |  | 2014-08-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-08-17 00:00:00
 |  |  | 2014-09-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-08-17 00:00:00
 |  |  | 2014-09-20 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-08-17 00:00:00
 |  |  | 2014-09-27 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-08-17 00:00:00
 |  |  | 2014-10-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-08-17 00:00:00
 |  |  | 2014-10-19 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-08-17 00:00:00
 |  |  | 2014-10-25 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-08-17 00:00:00
 |  |  | 2014-11-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-08-17 00:00:00
 |  |  | 2014-11-08 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-08-17 00:00:00
 |  |  | 2014-11-23 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-08-25 00:00:00
 |  |  | 2014-11-29 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-08-25 00:00:00
 |  |  | 2014-12-02 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-08-25 00:00:00
 |  |  | 2014-12-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-08-25 00:00:00
 |  |  | 2014-12-14 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-08-25 00:00:00
 |  |  | 2014-12-21 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-08-25 00:00:00
 |  |  | 2014-12-26 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-08-25 00:00:00
 |  |  | 2014-12-29 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-08-25 00:00:00
 |  |  | 2015-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-08-25 00:00:00
 |  |  | 2015-01-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-08-25 00:00:00
 |  |  | 2015-01-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-08-31 00:00:00
 |  |  | 2015-01-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-08-31 00:00:00
 |  |  | 2015-02-07 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-08-31 00:00:00
 |  |  | 2015-02-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-08-31 00:00:00
 |  |  | 2015-02-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-08-31 00:00:00
 |  |  | 2015-03-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-08-31 00:00:00
 |  |  | 2015-03-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-08-31 00:00:00
 |  |  | 2015-03-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-08-31 00:00:00
 |  |  | 2015-03-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-08-31 00:00:00
 |  |  | 2015-04-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-08-31 00:00:00
 |  |  | 2015-04-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-08-31 00:00:00
 |  |  | 2015-04-25 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-08-31 00:00:00
 |  |  | 2015-04-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-08-31 00:00:00
 |  |  | 2015-05-02 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-08-31 00:00:00
 |  |  | 2015-05-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-08-31 00:00:00
 |  |  | 2015-05-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2014-08-31 00:00:00