Update 2009 dates to 2010 dates

  • Thread starter Thread starter EllenM
  • Start date Start date
E

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
 
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.
 
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
 
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.
 
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.
 
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
 
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).
 
Back
Top