I need to calculate the number of weeks between two dates. So far so simple. However I would like my weeks to run from Monday to Friday. The formula I am currently using is this:

=TRUNC(((B1-C1)/7*-1)&" Weeks"

But this only works for weeks running Monday to Monday. I want my weeks to run from Monday to Friday. Anybody any ideas?