=TODAY()+MOD(DATE(2006,1,12)-TODAY(),14) should do it.


"GYRO" wrote:


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.



--
GYRO
------------------------------------------------------------------------
GYRO's Profile: http://www.excelforum.com/member.php...o&userid=29994
View this thread: http://www.excelforum.com/showthread...hreadid=496848