+ Reply to Thread
Results 1 to 4 of 4

Count the number of weeks between two dates of a different year

  1. #1
    Registered User
    Join Date
    09-09-2013
    Location
    Philippines
    MS-Off Ver
    Excel 2010
    Posts
    5

    Count the number of weeks between two dates of a different year

    Good day,

    I don't have any problems when I'm counting how many weeks between two dates when they are in the same year.

    Example

    A1: Inception Date:
    A2: Completion Date:
    B1: 5/2/2014
    B2: 11/6/2014
    B3: = WEEKNUM(B2) - WEEKNUM(B1)

    if I replace a date in cell B2 like 3/5/2015 it returns a negative value (-8) because the completion date is on the next year already. Can you help me sort it out? Thanks in advance!!

  2. #2
    Registered User
    Join Date
    02-05-2014
    Location
    Tbilisi, Georgia
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: Count the number of weeks between two dates of a different year

    Dear Jason,
    Why shouldn't you try this kind of solution:
    =ROUNDUP((B2-B1)/7,0)
    This seems simple but sure that it gives the correct result.

    regards,
    giorgi

  3. #3
    Registered User
    Join Date
    09-09-2013
    Location
    Philippines
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Count the number of weeks between two dates of a different year

    Hi Giorgi,

    I actually thought of it, too, but I was looking into other options using WEEKNUM. But if there's no other way, then I'd most probably use this.

    Thanks

  4. #4
    Registered User
    Join Date
    10-02-2014
    Location
    Sylmar, Ca
    MS-Off Ver
    2011
    Posts
    44

    Re: Count the number of weeks between two dates of a different year

    I would try the absolute value of WEEKNUM(B2) - WEEKNUM(B1). This will give you weeks between and then a new column for =year() then you can get the year difference and multiply by 52 weeks and add them

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 12-17-2013, 06:30 AM
  2. [SOLVED] Count weeks betweens dates
    By krista_o in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-05-2013, 12:15 PM
  3. Replies: 3
    Last Post: 05-29-2013, 01:57 PM
  4. A function to count the number of weeks between dates?
    By DorothyFan1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-03-2011, 09:25 AM
  5. [SOLVED] How do I count number of occurrences (dates) in a rolling year?
    By ShirleyTR in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-22-2005, 02:05 PM

Tags for this Thread

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