Ask Your Question
0

Edit dates for new year on chart [closed]

asked 2013-01-28 13:27:05 +0100

kwbeall gravatar image

updated 2013-01-29 14:13:27 +0100

manj_k gravatar image

Hi, I am a new user and have an excel chart for logging work hours for each day of the year of 2011. I want to edit for use in 2012 and 2013. I've saved the chart as 2012 and have changed column 1 row 3 from January 1, 2011 to January 1, 2012. How do I edit the rest of the column without having to make 365 changes? Thank you.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-20 23:50:32.971108

Comments

Mark cells of A3-A367, then select Edit-Fill-Series, Mark Date, Day and click Ok

B.Horvat gravatar imageB.Horvat ( 2013-01-28 15:06:34 +0100 )edit

Thank you; perfectly concise!

kwbeall gravatar imagekwbeall ( 2013-02-16 01:11:27 +0100 )edit

3 Answers

Sort by » oldest newest most voted
1

answered 2013-01-28 15:00:03 +0100

B.Horvat gravatar image

Mark cells of A3-A367, then select Edit-Fill-Series, mark Date, Day and click Ok.

edit flag offensive delete link more
0

answered 2013-01-28 18:12:02 +0100

Pedro gravatar image

Type January 2nd, 2012 on column 1 row 4 and then select the two cells. Release the mouse button and then A) double click on the black square (on the bottom right corner of the selection) IF column 2 is filled with data until line 365 OR B) click and drag the black square (on the bottom right corner of the selection) down to row 368

edit flag offensive delete link more
0

answered 2013-01-28 17:16:17 +0100

horst gravatar image

Assuming your old dates are in column A.

Goto Column B and enter the formula "=A4+365". This gives you the date in 2012 with same day.

Now copy the formula all the way down til next to December, 31.

Select the formula cells from Jan 2 until Dec 31, copy them to clipboard.

Goto cell A4 "Paste Special" and check Text, Number, Date, uncheck Formula. Hit enter.

This should do the trick.

edit flag offensive delete link more

Question Tools

Stats

Asked: 2013-01-28 13:27:05 +0100

Seen: 85 times

Last updated: Jan 28 '13