Roger, thank you so much. You cannot imagine how frustrating it was to get
sorted, but thanks
A

"Roger Govier" wrote:

Hi Andy

Your problem is the column. You are using Column(C2) as your staring test
value, which returns 3.
Sunday is day 1 with Weekday().
Change your start to Column(A2) and copy across and all works fine.
{=IF($F2="SAME DAY",0,
SUM(IF(WEEKDAY($C2-1+ROW(INDIRECT("1:"&TRUNC($F2-$C2)+1)))
=COLUMN(A2),1,0)))}
--
Regards
Roger Govier

"Andy" wrote in message
...
Following on from here...
http://www.microsoft.com/office/comm...8-9139b6cf04cd

I'm still struggling. I've uploaded a file here in anyone would be able to
help further?

http://megafileupload.com/en/file/97...pancy-xls.html

Thanks in advance.