T
T
todoman2022-02-10 13:46:35
PHP
todoman, 2022-02-10 13:46:35

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.

6204ecf9c98a2631183411.jpeg

Thanks in advance, I always choose the answer-solution.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
G
Grigory Boev, 2022-02-10
@todoman

=$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 question

Ask a Question

731 491 924 answers to any question