+ Reply to Thread
Results 1 to 3 of 3

Formula to calulate number weeks and days between two dates

  1. #1
    Registered User
    Join Date
    12-01-2009
    Location
    Louisiana
    MS-Off Ver
    Excel 2007
    Posts
    3

    Question Formula to calulate number weeks and days between two dates

    I need to know if there is a formula that can calculate the number of weeks and remaining days between two dates. Example: Start Date: 10/15/2009 End Date: 12/31/2009, I need the result to be 11 weeks, 1 day. I would appreciate any helpful input. Thanks!
    Last edited by tajones73; 12-01-2009 at 01:39 PM.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Formula to calulate number weeks and days between two dates

    If start date is A1 and end date B1 then

    C1:
    =INT((B1+1-A1)/7)&" Week(s), "&MOD(B1+1-A1,7)&" Day(s)"

  3. #3
    Registered User
    Join Date
    12-01-2009
    Location
    Louisiana
    MS-Off Ver
    Excel 2007
    Posts
    3

    Talking Re: Formula to calulate number weeks and days between two dates

    It worked out great!!! Thanks so much!!!

+ 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.6.0 RC 1