Dual code help. Unable to come up with a code to perform functions

Hello,
I have a dual code to do on a spreadsheet. I would like to put a date in one column (lets call it cell A1) which would in return put another date in a separate column but it would be dated 30 days ahead (let's call this cell A3).
Then, then I put a date in a totally different column (cell A2), it would clear the cell that has the 30 day future date (Cell A3).
I want to be able to do this in several rows, approx 200. What formula in VB would I use for all of this?
HELP!!!!

I completely botched by wording and cell references. Sorry about that!
Let me rephrase everything with the correct cell references.
I have a dual code to do on a spreadsheet. I would like to put a date in one column (lets call it cell C2) which would in return put another date in a separate column but it would be dated 30 days ahead (let's call this cell F2).
Then, when I put a date in a totally different column (cell E2), it would clear the cell that has the 30 day future date (Cell F2).
Sorry for the confusion, been a long day.

The same general idea works…
Try this formula in cell F2.

Please Login or Register  to view this content.

This is PERFECT!!!
Thank you so much. I can do basic things in Excel but the code you helped with is a tiny bit beyond my knowledge. Where would you recommend I look so I could learn these types of formulas?
Thanks,
Justigger