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" <(E-Mail Removed)> wrote in message
news:135932D0-28E2-4885-97AA-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:135932D0-28E2-4885-97AA-(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
news:1248B2F0-CD42-40F6-A377-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:135932D0-28E2-4885-97AA-(E-Mail Removed)...
>> > 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
>>
>>
>> .
>>