Please avoid all caps, it's harder to read and considered rude




to get number of weeks


=(END-START)/7


without decimals


=INT((END-START)/7)


one might also round to the nearest integer


=ROUND(((END-START)/7),0)


--


Regards,


Peo Sjoblom


--


Regards,


Peo Sjoblom

"MARIEM" wrote in message
...
I WANT A FORMULALA TO CALCULATE 10/01/2007 FROM 10/09/2007 TO GET NUMBER OF
WEEKS 9DURATION)