Ah thanks heaps!
I don't understand the second way, but I do the first. That makes
sense, I thought it would be something that simple. Thanks mate.

Now my formula is complete! :P
=COUNTIF(INDIRECT(ADDRESS(2,MATCH(NOW()+CHOOSE(WEE KDAY(NOW()),5,4,3,2,1,7,6),$1:$1))):IV2,$B$20)*3


--
dark
------------------------------------------------------------------------
dark's Profile: http://www.excelforum.com/member.php...o&userid=27723
View this thread: http://www.excelforum.com/showthread...hreadid=472378