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

[MARIEM]

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

 

[dan dungan]

See Chip Pearson's datedif page:

http://www.cpearson.com/excel/datedif.aspx

 

[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

 

[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 ?

 

[dan dungan]

Hi David,

Woops. You're right.

Thanks,

Dan