Cheers Max.

I though it was as simple as that but I keep coming up with a 'false'
result using the formula below.....

=IF(AND(DAY(TODAY()-1)=1,DAY(TODAY()-1)<=6),AVERAGE(OFFSET(A536,,MATCH(TODAY()-1,$338:$338,0)-1,,-(MATCH(TODAY()-1,$338:$338,0)-MATCH(DATE(YEAR(TODAY()-1),MONTH(TODAY()-1),1),19:19,0)+1))))

Absoultely stumped.....


--
Kstalker
------------------------------------------------------------------------
Kstalker's Profile: http://www.excelforum.com/member.php...o&userid=24699
View this thread: http://www.excelforum.com/showthread...hreadid=395995