Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 75
  • Last Modified:

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?
0
agwalsh
Asked:
agwalsh
1 Solution
 
Rgonzo1971Commented:
Hi,

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

Regards
0
 
QlemoC++ 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.
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
agwalshAuthor Commented:
Ah, it's always the simple things... thanks for that.
0
 
QlemoC++ DeveloperCommented:
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

Featured Post

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!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now