The numbers you are using in your example do not make sense to me. First,
there are 52 weeks in a year, not 100, unless the 100 stands for something
else. Second, your week range percentages won't get anywhere near the 100
value you are using before hitting 100%. Third, your week ranges are
varying... there is one less week in the 4-6 weeks span than either of the
other two shown or what is left over for the implied 11-12 final weeks span.
Could you give more realistic numbers for what you are looking for?

Rick


"tsony" wrote in message
...
David,

Sorry to bother you. One more question. This is related to the old one.
After finding the number of weeks there is another classification. if it
is 0
- 3 weeks 25% of 100
4 - 6 weeks 50% of 100 7 - 10 weeks 75% of 100. Which formula we use to
find
the result.

"David Biddulph" wrote:

You are saying you want to add 1 to the result of the B2-A2 subtraction.
Do
you need someone to tell you how to add 1 to B2-A2?
--
David Biddulph

"tsony" wrote in message
...
Dear David,

If we include the end date what formula we use for eg 01/01/08 to
21/01/08
number of days should be 21. if we deduct the two dates the result
comes
to
20, please advice

"David Biddulph" wrote:

=INT((B2-A2)/7)&" weeks and "&MOD(B2-A2,7)&" days"
--
David Biddulph

"tsony" wrote in message
...
Is anybody knows how to deduct two dates and the result should be in
number
of weeks and days (eg. 26 days should be 3 weeks and 5 days)?