What does DATEDIF(A1,A2,"d") do for you that A2-A1 wouldn't (apart from
rounding down to an integer)?

Also, are you sure that you want to round the number of days/7 to the
nearest integer, rather than rounding down? Have you tried your formula
with a 4 day difference, for example?

Perhaps =INT((A2-A1)/7)&" weeks "&INT(MOD(A2-A1,7))&" days" ?
[The second INT function isn't necessary if we know that A1 and A2 contain
only dates, not date and time combinations.]
--
David Biddulph

"pinmaster" wrote in message
...
Hi,

This may be a bit excessive but try this:

=ROUND(DATEDIF(A1,A2,"d")/7,0) &" weeks
"&DATEDIF(A1,A2,"d")-ROUND(DATEDIF(A1,A2,"d")/7,0)*7&" days"

HTH
Jean-Guy

"ASI" wrote:

Is it possible to create a formula to tell me how many weeks are left
within
a time frame if the dates are not in the same year?

Example:
12/01/07 to 11/30/08 (timeframe)
06/15/08 (date)
How many weeks are left from 06/15/08 until 11/30/08?

--
Thanks, Melanie