This would seem like something so many people would want, I'm very surprised that, after scouring the internet, I couldn't find anything that adresses this issue. First of all, I'm totally inexperienced with VBA, but I'm experienced in C, C++, MATLAB and the like, so don't worry about scaring me with tech, I'm simply trying to figure out how to do this without first spending weeks or months learning VBA on my own before attempting to implement this.

So, what I am trying to do is have, on a single spreadsheet, a list of tasks with due dates, however, the due dates change. They change because after a due date has passed, you have a new due date. I don't want to have pages and pages of task sheets, just one task sheet, and I don't want to manually change the due dates every week or every month, etc. I want to, once I enter in a start date, all these due dates will automatically update to the next due date based on if today's date has surpassed the due date. It will compile all the different tasks in this program, some are due weekly, some are due once every other week, others monthly, some quarterly, and other annually. They will all be on the same task sheet and once the due date has passed, the value in the "Due Date" cell will need to change to a new due date. I included a picture to give you an idea of the template. Don't worry about the conditional formatting, I have that already figured out. All I'm concerned with is having the due date replaced by a new value once today's date has passed the due date. Thanks! Screen Shot 2012-10-25 at 3.41.18 PM.jpg