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