You don't really need DATEDIF for calculating the number of days between
2 dates

=X2-B2

would suffice

so for weeks

=(X2-B2)/7

or if you want weeks and days in text...

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


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=521961