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.

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.

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.