Copy down dates in Excel - incrementing by years not days

Posted on 2016-07-15
Last Modified: 2016-07-15
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?
Question by:agwalsh
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 51

Accepted Solution

Rgonzo1971 earned 500 total points
ID: 41711848

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

LVL 70

Expert Comment

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

Author Comment

ID: 41711881
@Qlemo - I know that's how I would do that by numbers but with dates it has always just incremented by days not years..
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Author Closing Comment

ID: 41711883
Ah, it's always the simple things... thanks for that.
LVL 70

Expert Comment

ID: 41711891
I've tested it (in 2010), and it works with date cell format.
LVL 31

Expert Comment

by:Subodh Tiwari (Neeraj)
ID: 41712602

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.

Featured Post

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question