How do I change the year in a range of cells
 

I am updating this years schedule spreadsheet to next years. Since the
"scheduled" date is the same from one year to the next I only need to change
the year from 2005 to 2006. Is there a way I can do this for all of the
cells in a column?

Thanks in advance for any suggestions.

Lee

How do I change the year in a range of cells
 

Since neither is a leap year, you just need to advance 365 days. So type 365
in some random cell and copy. Then select all your date cells and Edit
Paste Special, select the 'add' radio button and click OK.

"Lee D" wrote:

I am updating this years schedule spreadsheet to next years. Since the
"scheduled" date is the same from one year to the next I only need to change
the year from 2005 to 2006. Is there a way I can do this for all of the
cells in a column?

Thanks in advance for any suggestions.

Lee

How do I change the year in a range of cells
 

Use a dummy column with the formula
=DATE(2006,MONTH(A1),DAY(A1))
Once you have the whole column filled in, copy and paste special, and select
values. Then delete the dummy collum.

You could also use
=A1+365
but you would lose a day every leap year (not until 2008 I think).

"Lee D" wrote:

I am updating this years schedule spreadsheet to next years. Since the
"scheduled" date is the same from one year to the next I only need to change
the year from 2005 to 2006. Is there a way I can do this for all of the
cells in a column?

Thanks in advance for any suggestions.

Lee

How do I change the year in a range of cells
 

Very easy:


1. Highlight the cells you want to change
2. Pull-down:
Edit Find 2005 in the findwhat field
2006 in the replacefield and click replace all
--
Gary''s Student


"Lee D" wrote:

I am updating this years schedule spreadsheet to next years. Since the
"scheduled" date is the same from one year to the next I only need to change
the year from 2005 to 2006. Is there a way I can do this for all of the
cells in a column?

Thanks in advance for any suggestions.

Lee

How do I change the year in a range of cells
 

Why not put the year in a cell, and then just build the scheduled dates from
that cell, something like

=DATE(M1,11,1)

etc.

Then only one cell to change each year.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Lee D" <Lee wrote in message
...
I am updating this years schedule spreadsheet to next years. Since the
"scheduled" date is the same from one year to the next I only need to
change
the year from 2005 to 2006. Is there a way I can do this for all of the
cells in a column?

Thanks in advance for any suggestions.

Lee

How do I change the year in a range of cells
 

Lee

Select the cells or column.

EditReplace

what: 2005
with: 2006


Gord Dibben Excel MVP

On Tue, 29 Nov 2005 08:35:03 -0800, "Lee D" <Lee
wrote:

I am updating this years schedule spreadsheet to next years. Since the
"scheduled" date is the same from one year to the next I only need to change
the year from 2005 to 2006. Is there a way I can do this for all of the
cells in a column?

Thanks in advance for any suggestions.

Lee

How do I change the year in a range of cells
 

Thank you. I knew there had to be an easier way.

"Sloth" wrote:

Use a dummy column with the formula
=DATE(2006,MONTH(A1),DAY(A1))
Once you have the whole column filled in, copy and paste special, and select
values. Then delete the dummy collum.

You could also use
=A1+365
but you would lose a day every leap year (not until 2008 I think).

"Lee D" wrote:

I am updating this years schedule spreadsheet to next years. Since the
"scheduled" date is the same from one year to the next I only need to change
the year from 2005 to 2006. Is there a way I can do this for all of the
cells in a column?

Thanks in advance for any suggestions.

Lee