Hi

I have the following formula in a lot of cells.

=SUMPRODUCT(--(DataDATE(2006,1,1)),--(Data<DATE(2008,1,1)),--(ISNUMBER(MATCH(MONTH(Data),{1},0))))

Is there a way to select all the cells involved with this formula and change
the date entries in the formula all together at the same time as it will take
a long time to go through every cell individually.

Anyone have any ideas.

Regards,

Mark