Hello!

I'm not sure why I'm having such a hard time with this. I have a field I have to have populated with the next occurance of any date given, plus 2 weeks.

Example: date in the past = 8/01/2007, output should read 8/15/2012
future date - 3/01/2012, output should read 3/15/2012.

How in the world to I make Excel do this? Please help! I'm going to drive myself crazy.