But of course DATEDIF(A2,B2,"d") is just B2-A2
--
David Biddulph

"Mike H" wrote in message
...
Try

=INT(DATEDIF(A2,B2,"d")/7) & " Weeks "&MOD(DATEDIF(A2,B2,"d"),7)&" Days"

Mike

"Lisa D" wrote:

I need to create a formula where it calculates the number of weeks and
days
between 2 dates.

For example:
A2 = 12/25/08
B2 = 1/30/09
C2 = 5 weeks 1 day

I found example formulas that calculates years, months and days....but no
weeks.

Any help is most appreciated!
Thanks!