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.
--
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

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

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

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.

"EllenM" wrote:

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

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

"EllenM" wrote:

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

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


.

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


.