NA Wrote:
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
Hi NA,
The trouble with this is:
Instead of just keeping two weeks ahead of todays date.
It Advances two weeks EVERY time you open the WorkBook.
So if you open the WorkBook four times today, the date would be
advanced eight weeks instead of two weeks.


--
Desert Piranha


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