Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell equal another cell
I have a statement that i update every month. There is a column that has the
current ending month. such as 10/31/08 this shows in each line in one column. i want to be able to change the first row to the next month such as 11/30/08 and have all the following cells in that column change at once. i can go to each cell and put the date cell in each one but is there a formula that i can use instead of having to to back and forth to the cell i change the date in? i can copy down but there are lines and underlines in the column and if i copy down the format will get copied also. i want each cell in this column to equal the one i change the date in. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell equal another cell
Say we are looking to fill column Z.
In Z1, enter: =DATE(YEAR(Y1),MONTH(Y1)+1,DAY(Y1)) this gets the new date from the old column. In Z2, enter: =Z1 and copy down the column This propagates the new date down the column -- Gary''s Student - gsnu200814 "JoAnn1877" wrote: I have a statement that i update every month. There is a column that has the current ending month. such as 10/31/08 this shows in each line in one column. i want to be able to change the first row to the next month such as 11/30/08 and have all the following cells in that column change at once. i can go to each cell and put the date cell in each one but is there a formula that i can use instead of having to to back and forth to the cell i change the date in? i can copy down but there are lines and underlines in the column and if i copy down the format will get copied also. i want each cell in this column to equal the one i change the date in. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
cell equal another cell
Try this in a copy of your file first...
Suppose your dates are in Col A Enter the new date in A1 Select Col A Choose Edit|Replace In Find What enter the new date In Replace With enter =$A$1 Click on Replace ALL "JoAnn1877" wrote: I have a statement that i update every month. There is a column that has the current ending month. such as 10/31/08 this shows in each line in one column. i want to be able to change the first row to the next month such as 11/30/08 and have all the following cells in that column change at once. i can go to each cell and put the date cell in each one but is there a formula that i can use instead of having to to back and forth to the cell i change the date in? i can copy down but there are lines and underlines in the column and if i copy down the format will get copied also. i want each cell in this column to equal the one i change the date in. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can I make cell "yes" equal 1, "no" equal 0 | Excel Discussion (Misc queries) | |||
Fomula where one cell is equal to the other cell content & format | Excel Discussion (Misc queries) | |||
How to point to (select) a cell to the left from a cell where I enter the = equal sign? | Excel Discussion (Misc queries) | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Turn cell red if today is greater or equal to date in cell | New Users to Excel |