Update 2009 dates to 2010 dates
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).
--
David Biddulph
"EllenM" wrote in message
...
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" wrote:
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.
--
David Biddulph
"EllenM" wrote in message
...
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
"Megan" wrote:
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.
--
If this has helped you, please click Yes
Thanks,
Megan
"EllenM" wrote:
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
.
|