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.