+ Reply to Thread
Results 1 to 2 of 2

Apply Week # based on starting every Sunday

  1. #1
    Forum Contributor
    Join Date
    08-17-2012
    Location
    Richmond, VA
    MS-Off Ver
    Excel 2007
    Posts
    158

    Apply Week # based on starting every Sunday

    Hello,

    I need to take some logic and apply it to a date. I am trying to take a date, and apply that date to a Week #. Each week # starts over every Sunday. So let’s say:

    - 06/02/2013 – 06/08/2013 = Week 1
    - 06/09/2013 – 06/15/2013 = Week 2
    - 06/16/2013 – 06/22/2013 = Week 3
    - 06/23/2013 – 06/29/2013 = Week 4

    To Clarify:
    - Each week # goes from Sunday – Saturday

    Another Example:
    - 06/30/2013 (which is a Sunday) should be applied to Week 1 in July
    - In this instance, Week 1 = 06/30/2013 – 07/06/2013

    Please let me know if I need to clarify anything.

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Apply Week # based on starting every Sunday

    Please Login or Register  to view this content.
    Where C1 is the last date of the week. ie 6/8/2013

    have attached example
    Attached Files Attached Files
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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