ExcelBanter - Info in Formulas

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Info in Formulas (https://www.excelbanter.com/excel-programming/376895-info-formulas.html)

santaviga

Info in Formulas

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

santaviga

Info in Formulas

Found it, Sorted

"santaviga" wrote:

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

All times are GMT +1. The time now is 07:56 PM.