Once you have the week ending date values in a column, filtering on that should be fairly straightforward unless there is some issue I am missing.
Thanks, Sam
Register Today!
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.