M MARIEM Oct 17, 2008 #1 I WANT A FORMULALA TO CALCULATE 10/01/2007 FROM 10/09/2007 TO GET NUMBER OF WEEKS 9DURATION)
D dan dungan Oct 17, 2008 #2 See Chip Pearson's datedif page: http://www.cpearson.com/excel/datedif.aspx
P Peo Sjoblom Oct 17, 2008 #3 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
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
