On Thu, 18 Aug 2005 13:37:02 -0700, "Rick, United Kingdom"
wrote:

A1 = Monday (what ever that date would be
B1 = Friday 2 weeks later.
And it is those 2 weeks i want to count to show a figure (2)

That is easy. =(B1-A1+3)/7

Then there would be circumstances of.
A2 = Wednesday
B2 = Friday. 1 week later

And what would you like to show as a result? 2? 1 3/7? 1 3/5? Something
else?

And then theres the whold bank holiday issue to deal with as well!

How do you want to deal with these? How will it affect the results?
Especially since your boss is counting partial weeks as full weeks, it's
difficult for me to know what you are thinking.

Is this going to be possible?

It depends on whether you can explain things more clearly, or someone else can
understand what you are trying to do.

I hope this clarifies things a bit


--ron