Copying groups of dates
In a blank cell enter 364, then click <copy on this cell. Then
highlight all the dates and Edit | Paste Special | Values (check) and
Add (check), then OK and <Esc. This will move all the dates on by 1
year minus 1 day, so that the dates will still point to Fridays. You
didn't make it clear if you wanted to keep last year's sheet - if so,
just copy it into the same workbook first then perform this operation
on the copied sheet.
Hope this helps.
Pete
|