count day's

[moshe]

when i enter a date in A1 and another date in B1, i want that in C1 should
calculate the days,
EX: if the dates are from 02/10/09 - 02/20/09, it should be written 1 week
and 3 days, (not 10 days)

 

[Bob Phillips]

=INT((B1-A1)/7)&" week "&MOD(B1-A1,7)&" days"

 

[Pecoflyer]

when i enter a date in A1 and another date in B1, i want that in C1
should
calculate the days,
EX: if the dates are from 02/10/09 - 02/20/09, it should be written 1
week
and 3 days, (not 10 days)

Try =int((finishdate-startdate)/7)&" weeks
"&mod((finishdate-startdate),7)&" days"


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faster

 

[Mike H]

Try this

=INT(DATEDIF(A1,B1,"d")/7) &" Weeks " &MOD(DATEDIF(A1,B1,"d"),7) & " Days"

Note that DATEDIF isn't documented in Excel so for help look here

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

Mike

 

[David Biddulph]

And note also that if you are counting days, you don't need DATEDIF.

DATEDIF(A1,B1,"d")
is the same as
B1-A1