How to find end of week between 2 dates

I need help please . How to find all end of weeks between 2 dates ( start date 20230101 and end date 20250131)
end of weeks : 20230107, 20230114, 20230121 etc

Thank you

Hi, have you tried DAYOFWEEK or DAYOFWEEK_ISO functions?