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

On Tue, 13 Nov 2007 16:34:01 -0800, 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?

A1: 12/01/07
A2: 11/30/08

B1: 6/15/08

Weeks left: =(A2-B1)/7

Format as number.

If you want whole weeks, either ROUND or TRUNCATE depending on what you want to
do with fractional weeks.
--ron

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

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

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

Thanks! Seems to working.
--



"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