How can you copy dates easily using Excel?
I want to double click the little plus on the side and have the SAME date copied. When I double click it adds a year to the date (e.g. 6/9/2006 --> 6/9/2007). This is very very annoying.
Observing members:
0
Composing members:
0
6 Answers
What little plus sign are you referring to?
If you have 2 dates in a row that are the same, select both, then grab the little box on the lower left of the selection and drag down -- the cells below will be auto-filled with the same date.
I was playing around with excell 2003. If you drag a date in that version, you have the option of incrementing by years, by days, by months, or just copying the same date.
Perchik - the little plus sign appears at the left bottom corner of a selected cell. If you double click it, it's equivalent to dragging until it "hits" a cell which has something in it on the bottom, or when the cells from the sides are empty. This may sound unclear, but test it and you'll see. As for your second response - I thought there was such an option, but how do you enable it is the question - would appreciate if you could tell me.
Sublime - Thanks, that worked. This will save me a lot of time - I need to copy the date column, so if Perchik comes through, perhaps his solution will be a bit better.
Thank you very much!!
Ok I've got it for you.
In excel 2003, the help file looks like this:
http://perchyk.info/datesExcel.png
I was gonna write up a little tutorial but that says it all. If that doesnt help, or doesnt work, or if you dont have 03, let me know and I'll figure it out for you
Thanks, I actually found this myself, but this is not very efficient (I have to do this thousands and thousands of time - I have to verify some data manually). I guess I'll stick to the "two dates per row" method.
Answer this question
This question is in the General Section. Responses must be helpful and on-topic.