How do I change cell data to a date one week in the future once that cell is equal to today’s current date?
Your data you will have to update yourself.
The calendar date shown by a cell can be updated by a formula. Assume “Monday, 2014-01-06” was the original date you started with. Then =VALUE("2014-01-06")+QUOTIENT(TODAY()+6-VALUE("2014-01-06");7)*7 will calculate the DayNumber (as calendaric dates are treted internally by spreadsheet software) of the actual day, if a monday, or the monday coming otherwise. To get it displayed in a date format you have to set it for the cell containing the formula.
This can easily be adapted to needs changed in detail. Best you prepare three cells for conating (e.g.):
C1: Starting date, say 2014-01-06 (which was a monday) (As a recognised date, not as a text!)
C2: Days offset (switching in advance)
C3: Weeks offset (switching in advance)
Any cell: =C1+QUOTIENT(TODAY()+6+C2+C3*7-C1;7)*7 and set to the proper numerical format for your dates
Editing: Sorry, both the formula above lacked a “+6” needed for the “minimum advance” . It is inserted now.