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.

 

[Simon Lloyd]

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)

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)

 

[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