Create Calculation to return number of weeks and days

L

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!
 
B

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
 
G

Gary''s Student

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

David Biddulph

With a 4 day gap, that returns 1 weeks -3 days.

Wouldn't it be better to change
=ROUND((B2-A2)/7,0) & " weeks " & (B2-A2)-7*ROUND((B2-A2)/7,0) & " days"
to
=INT((B2-A2)/7) & " weeks " & MOD(B2-A2,7) & " days" ?
 
S

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top