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.

10.01.2016

10.01.2016

11.01.2016

11.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.

asked July 8th 19 at 16:43

1 answer

answered on

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 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