If you wanted to have the date changed so that when the workbook opens it checks the date and if the date is less than the current date (in the past) then it will add on 7 days. So say if you set cell A5 to the 17-7-2012 (Tuesday) and the workbook is opened today the following code will add 7 days to A5 -> making it the 24/7/2012. This code would work if the workbook is opened at least once a week.
This would go into ThisWorkbook and not into a module so it is run every time the workbook is opened
Bookmarks