Try instead:

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

Replaced : " 19:19 " in your posted formula
with: " $338:$338 "

Believe the above is the main error part
... how on earth did the " 19:19 " creep into the picture ? <g

I've also added a phrase: "Formula_OR_Value_if_FALSE"
since your posted formula was w/o this value
(just change the phrase to whatever
you want returned as the value if FALSE.)

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Kstalker" wrote in
message ...

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(TODA
Y()-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