+ Reply to Thread
Results 1 to 5 of 5

Week Numbers base on Date Range

  1. #1
    Registered User
    Join Date
    06-22-2017
    Location
    USA
    MS-Off Ver
    2016
    Posts
    8

    Week Numbers base on Date Range

    is there a way to get the week numbers from a date range?

    if a have a date range : 1/1/2017 - 2/1/2017, what Week Numbers those dates belong to??

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Week Numbers base on Date Range

    I'm not sure if this will work in all cases but try this with your start date in A1 and end date in B1:

    =IF(A$1+(ROWS(A$1:A1)-1)*7<=B$1,WEEKNUM(A$1+(ROWS(A$1:A1)-1)*7),"")

  3. #3
    Registered User
    Join Date
    06-22-2017
    Location
    USA
    MS-Off Ver
    2016
    Posts
    8

    Re: Week Numbers base on Date Range

    Im getting the "" result.

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,610

    Re: Week Numbers base on Date Range

    is 1/1/2017 - 2/1/2017 a string in one cell, or dates in two cells?
    Ben Van Johnson

  5. #5
    Registered User
    Join Date
    06-22-2017
    Location
    USA
    MS-Off Ver
    2016
    Posts
    8

    Re: Week Numbers base on Date Range

    two cells. one is "start date" and the other one "end date"

+ 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. [SOLVED] Finding the average of positive numbers base on the previous date
    By top00001 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-27-2015, 03:54 AM
  2. Lookup/ Return a value within date range base on criteria
    By kelkelkel08 in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 01-16-2014, 05:10 AM
  3. Calculate week numbers from custom date
    By Lord Tink in forum Excel General
    Replies: 10
    Last Post: 06-06-2012, 08:57 AM
  4. count base on the day of the week
    By sanlen in forum Excel General
    Replies: 9
    Last Post: 01-27-2011, 08:40 AM
  5. Convert date range to week ending date
    By minkus in forum Excel General
    Replies: 5
    Last Post: 11-29-2010, 04:30 PM
  6. [SOLVED] Adding Week Numbers with date Functions
    By huston1679 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-17-2009, 11:16 PM
  7. [SOLVED] Transpose week numbers to date
    By Lewej in forum Excel General
    Replies: 2
    Last Post: 05-06-2005, 08:06 AM

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