Calculating Previous X Weeks at the New Year Turnover
Hello, I've got this handy formula calculating if a row record is from the previous 5-weeks that worked great up until the new year. Now I need something to know that Week 1-2023 and Weeks 49-52-2022 are what should be considered. It's probably not as hard as I'm making it out to be and I'm sure someone has run into this in years past.
Here's what I have right (for a checkbox column):
=IF(AND(WEEKNUMBER(TODAY()) - [Week Number]@row < 6, WEEKNUMBER(TODAY()) - [Week Number]@row > 0), 1, 0)
Other suggestions on how anyone has gotten something like this to work for them would be helpful.
Help Article Resources
Check out the Formula Handbook template!