Sunday would be the last day of the week.
This macro must be flexible and able to work over several years, so I don't know the last sunday of the previous year.
If each year had 52 weeks, this would have been easy, but some years have 53 weeks and I don't know if there is a simple way of finding out which ones they are.