Excel AutoFill dates for 3 the same?

Tell me how to fill in the Excel column of dates in blocks of 3 the same? The example below
10.01.2016
10.01.2016
10.01.2016
11.01.2016
11.01.2016
11.01.2016
12.01.2016
12.01.2016
12.01.2016

UPD: a simple selection and pulling down does not work - the dates are just copied, the setting "fill" enabled.
July 8th 19 at 16:43
1 answer
July 8th 19 at 16:45
Solution
You can use formulas.
The first three cells to be filled manually. With the fourth and enter the formula below*:
=IF(AND(A3=A2;A2=A1);A3+1;A3)
We get the desired result. Yes, the formula could be done smarter and prettier, but it works, the cost of the solution should not be unreasonably high :)

* if excel English, if Russian, the formula should be translated, thanks to Microsoft!
The formula for Russia =IF(AND(A3=A2,A2=A1),A3+1,A3) - Erika88 commented on July 8th 19 at 16:48
By the way, sometimes, to avoid confusion, it makes sense the results of the formulas in this and similar cases, to allocate, copy, and paste back as values - but it will change someone the value in the cell, the primary source, and all values "go away." - Adrienne81 commented on July 8th 19 at 16:51

Find more questions by tags AutocompleteExcel