Calculating weeks and days between dates

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"

Hi djr1970

Sorry, you are wrong..

Works perfectly...

Well done daddy..!