You are correct. My formula is badly flawed.
--
Gary''s Student - gsnu200822


"David Biddulph" wrote:

With a 4 day gap, that returns 1 weeks -3 days.

Wouldn't it be better to change
=ROUND((B2-A2)/7,0) & " weeks " & (B2-A2)-7*ROUND((B2-A2)/7,0) & " days"
to
=INT((B2-A2)/7) & " weeks " & MOD(B2-A2,7) & " days" ?
--
David Biddulph

"Gary''s Student" wrote in message
...
In C2 enter:
=ROUND((B2-A2)/7,0) & " weeks " & (B2-A2)-7*ROUND((B2-A2)/7,0) & " days"

--
Gary''s Student - gsnu200822


"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!