Answer the question
In order to leave comments, you need to log in
Excel: How to make autocomplete from duplicate but incrementing dates?
Please tell me:
if the dates were in a row, then it is clear that by filling in a couple of dates you can stretch further and get auto-completion of dates at least a year ahead. But it is important for me that each date is repeated twice (see screenshot) and at the same time that this sequence grows. Couldn't win. Excel thinks I want it to repeat the cycle:
10.02
10.02
11.02
11.02
12.02
12.02
10.02
10.02
11.02
11.02
12.02
12.02
etc.
And I need:
10.02
10.02
11.02
11.02
12.02
12.02
13.02
13.02
14.02
14.02
etc.
Thanks in advance, I always choose the answer-solution.
Answer the question
In order to leave comments, you need to log in
=$A$1+ЦЕЛОЕ(СТРОКА()/2)
$A$1 contains the first date
2 is the number of repetitions
...and propagate the formula down
Demo table
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question