<div>
If you write the correct dates into two or three cells, and then drag those cells down, you should see an increment as expected.
</div>


If you write the correct dates into two or three cells, and then drag those cells down, you should see an increment as expected.

<div>
@Qlemo - I know that's how I would do that by numbers but with dates it has always just incremented by days not years..
</div>


@Qlemo - I know that's how I would do that by numbers but with dates it has always just incremented by days not years..

<div>
Ah, it's always the simple things... thanks for that.
</div>


Ah, it's always the simple things... thanks for that.

<div>
I've tested it (in 2010), and it works with date cell format.
</div>


I've tested it (in 2010), and it works with date cell format.

<div>
@Qlemo<br />
<br />
He didn't get your suggestion correctly. :)<br />
<br />
@agwalsh<br />
<br />
What Qlemo meant was, input 1/1/2016 in A1 and input 1/1/2017 in A2, then select A1:A2 and drag it down.
</div>


@Qlemo

He didn't get your suggestion correctly. :)

@agwalsh

What Qlemo meant was, input 1/1/2016 in A1 and input 1/1/2017 in A2, then select A1:A2 and drag it down.

<div>
<div class="content wysiwyg-content">
I enter a date into my Excel 2010 sheet, then I copy it down. It automatically increments by days e.g. it will read<br />
1/1/2016<br />
2/1/2016<br />
<br />
However a colleague copies down her dates (also Excel 2010) and it increments as follows:<br />
1/1/2016<br />
1/1/2017<br />
<br />
Why is that happening?
</div>
</div>


I enter a date into my Excel 2010 sheet, then I copy it down. It automatically increments by days e.g. it will read
1/1/2016
2/1/2016

However a colleague copies down her dates (also Excel 2010) and it increments as follows:
1/1/2016
1/1/2017

Why is that happening?

Copy down dates in Excel - incrementing by years not days

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.