+ Reply to Thread
Results 1 to 6 of 6

Thread: Calculating weeks and days between dates

  1. #1
    Registered User
    Join Date
    12-19-2011
    Location
    Llandrindod Wells, Wales
    MS-Off Ver
    Excel 2003
    Posts
    9

    Calculating weeks and days between dates

    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

  2. #2
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2007
    Posts
    10,057

    Re: 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"
    Audere est facere

  3. #3
    Registered User
    Join Date
    12-19-2011
    Location
    Llandrindod Wells, Wales
    MS-Off Ver
    Excel 2003
    Posts
    9

    Unhappy Re: Calculating weeks and days between dates

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

  4. #4
    Valued Forum Contributor Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens Greece
    MS-Off Ver
    Excel 2003
    Posts
    2,303

    Re: Calculating weeks and days between dates

    Hi djr1970

    Sorry, you are wrong..

    Works perfectly...

    Well done daddy..!
    Attached Files Attached Files
    Regards

    Fotis.

    I am proud that i am Greek.

    Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?

    Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Please,mark your thread [SOLVED] if you received your answer.


    My Avadar picture, is from Athens Acropolis.
    http://www.theacropolismuseum.gr

    http://www.visitgreece.gr/

  5. #5
    Registered User
    Join Date
    12-19-2011
    Location
    Llandrindod Wells, Wales
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Calculating weeks and days between dates

    Thank you very much!

  6. #6
    Valued Forum Contributor Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens Greece
    MS-Off Ver
    Excel 2003
    Posts
    2,303

    Re: Calculating weeks and days between dates

    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.
    Regards

    Fotis.

    I am proud that i am Greek.

    Just to know every one.We Greeks, we are nοt proud of our politicians. Υou?

    Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Please,mark your thread [SOLVED] if you received your answer.


    My Avadar picture, is from Athens Acropolis.
    http://www.theacropolismuseum.gr

    http://www.visitgreece.gr/

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.2.0