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.

I've not looked at your links, if its a follow on from that thread then
you should post in that thread so people can follow it easy, that said,
take a look at Chip Pearsons site it is well explained with working
examples 'Dates And Times In Excel'
(http://www.cpearson.com/excel/datetime.htm)

Andy;308505 Wrote:
Following on from here...
'Discussion Groups Home' (http://tinyurl.com/cskmr8)

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

'Copy of NGH Ortho Ward Occupancy.xls' (http://tinyurl.com/cjpuxv)

Thanks in advance.


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=86244

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.

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.