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
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?
LVL 1
agwalshAsked:
Who is Participating?
 
Rgonzo1971Connect With a Mentor Commented:
Hi,

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

Regards
0
 
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
If you write the correct dates into two or three cells, and then drag those cells down, you should see an increment as expected.
0
 
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..
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
agwalshAuthor Commented:
Ah, it's always the simple things... thanks for that.
0
 
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
I've tested it (in 2010), and it works with date cell format.
0
 
Subodh Tiwari (Neeraj)Excel & VBA ExpertCommented:
@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.
0
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.