Solved

Copy down dates in Excel - incrementing by years not days

Posted on 2016-07-15
6
35 Views
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
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?
0
Comment
Question by:agwalsh
6 Comments
 
LVL 49

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 41711848
Hi,

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

Regards
0
 
LVL 69

Expert Comment

by:Qlemo
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.
0
 

Author Comment

by:agwalsh
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..
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Closing Comment

by:agwalsh
ID: 41711883
Ah, it's always the simple things... thanks for that.
0
 
LVL 69

Expert Comment

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

Expert Comment

by:Subodh Tiwari (Neeraj)
ID: 41712602
@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

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

832 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