I have pretty much ripped out my hair trying to figure this out. There's gotta be a way. Please help!!

I have a spreadsheet in which there is one cell I would like to have automatically change every two weeks.

For example, on 12/30/2005, I would like this cell to automatically change to 01/12/2006. Then, on 01/13/2006, I would like this cell to automatically change to 01/26/2006.

Is there any way to do this? I assume I will need some kind of VB programming.