Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


Copy down dates in Excel - incrementing by years not days

Posted on 2016-07-15
Medium Priority
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 53

Accepted Solution

Rgonzo1971 earned 2000 total points
ID: 41711848

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

LVL 71

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..
Independent Software Vendors: 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 71

Expert Comment

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

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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

Question has a verified solution.

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

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

618 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