Changing Multiple Dates

[Sandpit]

Hi All,

I have the following formula in Rows:

=COUNTIFS(A$3:A$15001,"01-JAN-13",K$3:K$15001,BU$1)+SUMIFS(T$3:T$15001,A$3:A$15001,"01-JAN-13",K$3:K$15001,BU$1)

I need to change the days consecutively for each month i.e. "01-JAN-13", "02-JAN-13" etc, is there an easy way to do this without having to do it manually for each day of the month please as there are other rows with different formulae which need changing in the same way?

Regards,

Sandpit

[Teethless mama]

Use cell reference instead of hard code.

[Dave H9]

As teethless mamma said. Please see attached example with helper column.

That's if we have interpreted your request correctly...

Hope that helps

Dave H

[Sandpit]

Sorry guys a little confused as to how to work that with the formulae I have in all the columns. The spread sheet looks something like this:
Untitled.jpg

Each one of the columns has a similar formula with slight differences but the dates are always with them.

[Dave H9]

Have a look at my previous attachment. Column C is the helper column and signifies the day from the date format dd/mm/yyy. the formula uses this column to determine the overall date to count.

Please Login or Register  to view this content.

PS I changed the formula slightly to the above. I had an extra bit which would have limited it to single digit dates ie 1-9.

Hope that helps

Dave H

[Sandpit]

Thanks to both of you, much appreciated!!

Regards

Sandpit