Retrieve Dates from Week Ranges

[RobRayborn]

I recieve Excel Workbooks that produce weekly forecasts.  Each workbook will forecast out 16 weeks, one column per week based on the Date the workbook was created. The problem comes after the 16 weeks the workbook starts grouping weeks together. Instead of W04, W05, W06, it lists W38-42, W43-47.
I eventually want to group all the weeks up into months. My problem is that once the column with the week designators get to the end of the year the week indicators show as W52-3, or the 52nd week of the current year through the 3rd week of the next year. No indication of YEAR is provided in the column headings. The only actual date comes either from the date in the cell of the sheet provided, or one of the dates from the import of the data, (Date Modified, Date Created.....).
How can show provide the crossover from one year to the next?

[dufoq3 · Accepted solution]

Hi @RobRayborn, you can use for W52-3 this logic: if number after "-" is less than number before "-" than add 1 year. If you want to help us with a solution - provide sample data in usable format (read note below my post if you don't know how to do that) and don't forget to provide expected result based on sample data.

[RobRayborn]

Clever, I'll give it a go.  Thanks for getting back so quickly.