Create Calculation to return number of weeks and days

[Lisa D]

I need to create a formula where it calculates the number of weeks and days
between 2 dates.

For example:
A2 = 12/25/08
B2 = 1/30/09
C2 = 5 weeks 1 day

I found example formulas that calculates years, months and days....but no
weeks.

Any help is most appreciated!
Thanks!

 

[Bernard Liengme]

If for you "WEEK" is any 7 days then weeks = =INT((B2-A2)/7) and days =
=MOD((B2-A2),7)

But it gets complicated if WEEK is a 'calendar week'?
If so does your week begin on Sunday or Monday?
If we start on Tuesday of week 1 and end on Wednesday or week 2, how may
weeks will this be for you purpose? It is two partial weeks and no complete
weeks.

best wishes

 

[Gary''s Student]

In C2 enter:
=ROUND((B2-A2)/7,0) & " weeks " & (B2-A2)-7*ROUND((B2-A2)/7,0) & " days"

 

[Mike H]

Try

=INT(DATEDIF(A2,B2,"d")/7) & " Weeks "&MOD(DATEDIF(A2,B2,"d"),7)&" Days"

Mike

 

[Lisa D]

That did it!!!!! Thank you soooooo much!!!!!!

Try

=INT(DATEDIF(A2,B2,"d")/7) & " Weeks "&MOD(DATEDIF(A2,B2,"d"),7)&" Days"

Mike

 

[Shane Devenshire]

Hi,

Try

=INT((B2-A2)/7)&" weeks "&MOD(B2-A2,7)&" days"

If this helps, please click the Yes button

Cheers,
Shane Devenshire

 

[Gary''s Student]

You are correct. My formula is badly flawed.