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.
Bookmarks