+ Reply to Thread
Results 1 to 4 of 4

Week number to date multiple or two years

  1. #1
    Registered User
    Join Date
    10-11-2022
    Location
    Chicago, IL
    MS-Off Ver
    2016
    Posts
    2

    Week number to date multiple or two years

    Thank you for the help in advance.

    In the sheet, I have columns that have the week number a product will launch F4 as well as other aspects of the project I4. With these, there is a formula that converts the week into a date D/M/Y =$A$1+(I4*7) with A1 being 12/29/22. Because of this spanning over the course of two years 2022 and 2023, when the week's number is converted, its only showing dates after 12/29/2022. If the week falls before 12/29/2022, it's still registering the date as 2023.

    The issue sits in rows 15-30 -Launch Date Week and Launch Date are correct-, but Spec Sheet Complete ', J, K and Full product Guide Complete M, N, O, weeks 43 and 51 should actually be 10/26/2022 and 12/21/2022, not 2023.

    Please let me know if this makes sense or if you need additional clarification.
    Attached Files Attached Files
    Last edited by BrockStar; 10-13-2022 at 05:27 PM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, Suffolk (England), but grew up in Sawley, Derbyshire
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2301 (Windows 11 22H2 64-bit)
    Posts
    65,649

    Re: Week number to date multiple or two years

    The file won't open - please try attaching it again.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  3. #3
    Registered User
    Join Date
    10-11-2022
    Location
    Chicago, IL
    MS-Off Ver
    2016
    Posts
    2

    Re: Week number to date multiple or two years

    I've re-attached it. I hope this helps

  4. #4
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,025

    Re: Week number to date multiple or two years

    I always do the opposite.
    I start from the date and determine the week and year from that.
    So do not determine the date from the year and week number.
    Then you will have no problem with the transition to the next year.
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

+ 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] Number of times a month/day falls on a certain day-of-week within a range of years
    By bird333 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-20-2020, 02:14 PM
  2. [SOLVED] Updating week number, start date of the week, and year from a column date that's populated
    By Raylou in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-28-2020, 11:11 AM
  3. counting week number of two different years
    By sanlen in forum Excel General
    Replies: 3
    Last Post: 12-17-2017, 12:13 PM
  4. X-Axis calendar week and year for multiple years
    By atestacc in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-12-2017, 11:15 AM
  5. Replies: 5
    Last Post: 04-11-2017, 09:23 AM
  6. Get years week from date
    By joang24 in forum Excel General
    Replies: 1
    Last Post: 05-19-2010, 07:36 AM
  7. week start date and end date based on week number
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-02-2009, 12:39 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