Results 1 to 4 of 4

Week number to date multiple or two years

Threaded View

  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.

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