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

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

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

See Chip Pearson's datedif page:

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

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

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)

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

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 ?
--
David Biddulph

"dan dungan" wrote in message
...
See Chip Pearson's datedif page:

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

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

Hi David,

Woops. You're right.

Thanks,

Dan