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