Calculating weeks and days between dates

**djr1970** · 12-19-2011, 11:35 AM

Hi,

I would like to calculate the number of weeks and days between two dates and then add up all the weeks and days together to get a total

for example:

From To
30/08/2011 19/12/2011 Calculate weeks & days between two dates
07/01/2011 29/03/2011 Calculate weeks & days between two dates
23/09/2010 10/10/2010 Calculate weeks & days between two dates
20/04/2010 11/05/2010 Calculate weeks & days between two dates
25/01/2010 19/04/2010 Calculate weeks & days between two dates
12/01/2010 24/01/2010 Calculate weeks & days between two dates

Calculate total number of weeks and days (all the above added together)

I have tried and ended up with 44 weeks and 18 days - i want this to show the correct 46 weeks and 4 days

Many thanks in advance

**daddylonglegs** · 12-19-2011, 11:42 AM

If you have dates in A2 and B2 then you can get the number of weeks between those with this formula in C2

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

for the total it's best to use a similar formula working off the original dates (rather than the previous formula results) so for dates in rows 2 to 7 get the total with this formula

=INT((SUM(B2:B7)-SUM(A2:A7))/7)&" weeks "&MOD(SUM(B2:B7)-SUM(A2:A7),7)&" days"

**djr1970** · 01-03-2012, 11:08 AM

Hi, I have tried this but it doesn't seem to work - sorry!

**Fotis1991** · 01-03-2012, 12:25 PM

Hi djr1970

Sorry, you are wrong..

Works perfectly...

Well done daddy..!

**djr1970** · 01-03-2012, 12:35 PM

Thank you very much!

**Fotis1991** · 01-03-2012, 01:07 PM

The thanks belong to daddylonglegs

Just trying to help you, showing you how the formulas work where you suggested ..

Glad to helped you.

Pls mark the tread, as SOLVED.