Take a look at what I have attached.
To test, enter the date you want (e.g. today's date) into the highlighted cell.
The table beneath give the number of weeks back from the test date (1 -65...so goes back over a year), the start date, the end date and the number I think you're looking for, the week number.
There are probably more elegant solutions.
|