Copy down dates in Excel - incrementing by years not days

I enter a date into my Excel 2010 sheet, then I copy it down. It automatically increments by days e.g. it will read

However a colleague copies down her dates (also Excel 2010) and it increments as follows:

Why is that happening?
Who is Participating?
Rgonzo1971Connect With a Mentor Commented:

If it's considered text by excel then it increments by the last digit

QlemoBatchelor and DeveloperCommented:
If you write the correct dates into two or three cells, and then drag those cells down, you should see an increment as expected.
agwalshAuthor Commented:
@Qlemo - I know that's how I would do that by numbers but with dates it has always just incremented by days not years..
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

agwalshAuthor Commented:
Ah, it's always the simple things... thanks for that.
QlemoBatchelor and DeveloperCommented:
I've tested it (in 2010), and it works with date cell format.
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:

He didn't get your suggestion correctly. :)


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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.