Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In Excel how do I delete or change the name of a range of cells? | Excel Discussion (Misc queries) | |||
adding the same prefix or suffix to a range of cells | Excel Discussion (Misc queries) | |||
Counting empty cells within a range of cells | New Users to Excel | |||
I Need to change reference sheet for all cells on a form | Excel Discussion (Misc queries) | |||
How do you change the size of a range of cells in a column/row | Charts and Charting in Excel |