# of weeks left based upon a date?

[ASI]

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?

 

[Ron Rosenfeld]

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

 

[pinmaster]

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

 

[FSt1]

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

 

[David Biddulph]

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.]

 

[ASI]

Thanks! Seems to working.