gyro -

The simplest way to do this is with an auto open sub on the Thisworkbook
module. Perhaps like:

Private Sub Workbook_Open()
With Sheet1.Cells(1, 1)
If .Value < Date Then .Value = .Value + 13
End With
End Sub

- voodooJoe

use an auto open sub to examine the value and change it if it mneets
"GYRO" wrote in message
...

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