Hi Mark

This would not be very easy to do, since you would find yourself going 
in circles it you would use any formula. The only way this could be 
achieved is using a macro with the spreadsheet, which would inspect the 
result of cell A6 and then decide whether to change to fixed value in D6 
or not. If the value in D6 had to be changed by way of a formula, you 
would have a "circular reference" error in the spreadsheet. As far as I 
know, Excel can't run a macro automatically when a workbook is loaded, 
so this will have to be done by putting a clickable button on the 
spreadsheet.

If you need the code for the button, please let me know.

At Neethling
Cape Town.


Mark Rode <[log in to unmask]> wrote:

I would like to have an Excel formula where as

C6=(TODAY)
D6=7/21/09
A6 =D6-C6 but....

A6 counts down the days from the 21st of the month. What I want it to
do is when A6 reaches 0, it changes D6 by increasing the month by
one, thus starting a new month countdown. How do I accomplish this. Thanks



-- 

___________________________________________________________
QOTW: I have a tip that can take 5 strokes off anyone's golf
      game. It is called an eraser.
      --Arnold Palmer

        The NOSPIN Group has added a new feature on our website,
           web based bulletinboard for questions and answers:
              Visit our sister website at http://nospin.com