With start date in A2 and end date in B2 as suggested previously try
=MATCH((B2-A2+1)/7,{0,4,7,11})/4
"tsony" wrote:
Sorry Rick,,
It is 11 - 13 100%
Thanks
"Rick Rothstein (MVP - VB)" wrote:
What is the last span of weeks to make 100% then?
Rick
"tsony" wrote in message
...
Rick,
100 is not weeks. It is only a number. The week ranges are varying, it is
not fixed. Is that helps you.
Thanks
"Rick Rothstein (MVP - VB)" wrote:
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)?