Dear community,
I'm looking to display data by week over year end. I've applied the =Week(Date) formula to get week numbers but I am struggling to sort the data in the correct order. My information is filtered using set analysis based on the dates to only show 13 weeks of information.
I want to order the weeks so that it would run 49,50,51,52,1,2,3,4,5 - then the next week would show 49,50,51,52,1,2,3,4,5,6 and so on.....
Many thanks for your help.
Best regards,
Drew
