Works well thanks Biff and Max.
I have one other question relating to this... I am trying to
incorporate a sumproduct function into the formula and cannot quite get
it to behave how I would like.
=IF(T25=0,0,IF(MATCH(TODAY(),$1:$1,0)-1<7,SUMPRODUCT((OFFSET(A3,,MATCH(TODAY(),$1:$1,
0)-1,,-7)),(OFFSET(A25,,MATCH(TODAY(),$1:$1,
0)-1,,-7)))/T25))-1,,-(MATCH(TODAY(),$1:$1,0)-1))),SUMPRODUCT((OFFSET(A3,,MATCH(TODAY(),$1:$1,
0)-1,,-7)),(OFFSET(A25,,MATCH(TODAY(),$1:$1, 0)-1,,-7)))/T25)
Again, if you get a minute could you take a look at the attached
formula and poitn out the error in my ways.
Thanks again.
Kristan
--
Kstalker
------------------------------------------------------------------------
Kstalker's Profile:
http://www.excelforum.com/member.php...o&userid=24699
View this thread:
http://www.excelforum.com/showthread...hreadid=395995