=mod(enddate - startsdate,7) will give the number of days.
so
=INT((enddate-startdate)/7)&" weeks "&MOD(enddate-startdate,7)&" days"
returns
3 weeks 4 days
--
Alex Delamain
------------------------------------------------------------------------
Alex Delamain's Profile:
http://www.excelforum.com/member.php...o&userid=11273
View this thread:
http://www.excelforum.com/showthread...hreadid=400393