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