A FORMULALA TO CALCULATE 10/01/2007 FROM 10/09/2007 TO GET #OF WEE

M

MARIEM

I WANT A FORMULALA TO CALCULATE 10/01/2007 FROM 10/09/2007 TO GET NUMBER OF
WEEKS 9DURATION)
 
P

Peo Sjoblom

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
 
D

David Biddulph

Dan,

Please correct me if I'm wrong, but doesn't DATEDIF work in days, months,
and years? As far as I am aware, DATEDIF doesn't work in weeks?
Surely for weeks it is merely a question of =(B2-A2)/7 ?
 
Top