Count of days between dates

[Andy]

Following on from here...
http://www.microsoft.com/office/com...misc&mid=05978e0c-cfe6-4c49-b1c8-9139b6cf04cd

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

http://megafileupload.com/en/file/97285/Copy-of-NGH-Ortho-Ward-Occupancy-xls.html

Thanks in advance.

 

[Roger Govier]

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)))}

 

[Andy]

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