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

 

[dan dungan]

Hi David,

Woops. You're right.

Thanks,

Dan