How to get a date to change to a future date AFTER that date has passed?

Hello guys,

I am looking for a couple of formulas that will change a particular date into another date in the future when that date has passed. Eg:

WEEKLY: 13/1/10 is turned into 20/1/10
YEARLY: 13/1/10 is turned into 13/1/11

I currently have this set up:
A1-13/1/10 (this is the date i am counting down to)
A2- this cell contains the current date =TODAY() )

I use this formula for the MONTH dates......=DATE(YEAR(A2),MONTH(A2)+1*(DAY(A2)>1),1).......

But now i am looking for 2 more formulas that can give me the next WEEK and YEAR dates. I am a bit of an Excel amateur so please excuse me...i try my best


Cheers
Casino

A1 can just be =Today()+MOD(4-WEEKDAY(Today()),7), where 4 represents the day of the week, in this case Wednesday.
B1 (or wherever the year is) can be =DATE(YEAR(TODAY())+(MONTH(TODAY())>=1)*(DAY(TODAY())>=13),1,13). Note that the (MONTH(TODAY())>=1)* part is put in only for illustrative purposes if you want to change it to a different month. If it's January, it is unnecessary. The 1 naturally refers to January and the 13 to the day.