hi
subtracting one date from another (and formated as number) gives the number
of days between the dates. after that you just divide by 7 to get weeks.
if A1 =6/15/08 and A2 = 11/30/08 then the formula would be
=(A2-A1)/7 = 24 weeks remaining. format as number.

regards
FSt1

"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