Hi!

It's not real clear exactly what you mean!

Do you want to count "full Monday through Friday weeks" between 2 dates?

The same for "part weeks"?

Biff

"Rick, United Kingdom" wrote
in message ...
Hi, need a bit of help on this one.
I need to be able to count weeks. (Mon-Fri).
I also have to be able to count part weeks (Thur-Fri)

Now i am guessing that i am gonna need to use 2 formlae to do this. but
don't have the faintest clue on either. Also will the two formulas clash?
therefore requiring one formula to do all? I am thinking this is gonna be
a
toughy. looked in loads of books and A) don't understand them. and B)
Don't
think they show it!

Thanks for any help