Compare previous year's weekly data

[DDT123]

Greetings, I'm needing a little help with finding previous year's data to compare with current year data.
Column A has dates from January 2, 2019 to current. If we're currently in weeknum 1 of 2022, i'm needing to see weeknum 51 and weeknum 52 of 2019 as well as weeknum 51 and 52 for 2020 and 2021. Also needing to see weeknums 1, 2, and 3 from the previous years to help forecast what this year's data may look like.

 

[Toadstool]

Hi DDT123,

Are you sure you want to use weeknum as you often have short weeks around a new year which would seem to make comparisons tricky?

 

[DDT123]

Hi DDT123,

Are you sure you want to use weeknum as you often have short weeks around a new year which would seem to make comparisons tricky?

View attachment 54351

Yes, we use the short weeks for forecasting as well.