Update 2009 dates to 2010 dates

[EllenM]

Hello,
I have a 2009 time card that needs updating to 2010. I have dates in week
ranges for instance, 1/4/2009 to 1/10/2009 which would be converted to
1/3/2010 to 1/9/2010. Is there an easy way to do this?

Thanks in advance,
Ellen

 

[Megan]

Do you just need to change the year? Or do you also need to change January
4th to January 3rd?

For the year, you can do a find and replace. Find 2009 and Replace with 2010.

 

[EllenM]

Actually, I need something like this to happen:
1/4/2009 becomes 1/3/2010
1/5/2009 becomes 1/4/2010
1/6/2009 becomes 1/5/2010

 

[David Biddulph]

You haven't explained which date format you are using, but I assume that you
mean you want to advance by 364 days, rather than by 11 months?

If so, you can either use formula =A2+364
or put 364 in a cell, copy, then select your range and use Edit/ Paste
Special/ Add.

 

[AnotherNewGuy]

You are actually just adding 2 weeks -- 364 days.

Type 364 in an empty cell. Copy to clipboard. Highlight area you'd like
converted. Click Paste-Special and select Add.

 

[AnotherNewGuy]

Aaarrruuuggg! When I clicked Post I noticed it said 2 weeks. Make that 52
weeks.

 

[EllenM]

Thanks so much David. Is there a way for me to retain my original
formatting? I have it displaying on the spreadsheet at "3-Jan" for instance,
and "1/3/2010" in the formula bar--that is to the right of the "fx".

And I'd like to advance the date by 364 days.

Thanks,
Ellen

 

[David Biddulph]

The way it displays in the spreadsheet is governed by Format/ Cells/ Number/
Date ... for that cell.
If you've got a format that you're happy with, either use the format
painter, or copy and Edit/ Paste Special/ Format.

The way it displays in the formula bar is probably controlled by your
Windows Regional Options (in Control Panel).