Constant Date In Adjacent Cell On Enter

    Hi there


    In Cell A1 I want to write a name, then Excel shall write the date for today in cell B1. I know how to do that. The problem is that the formula I use in cell B1 is:
    [bf]=IF(ISTEXT(A1);TODAY();" ")[/bf]
    This formula will today write 28/2-08 but tomorrow the cell will change to 29/2-08 without changing the name in cell A1. How can make it so that cell B1 don't change tomorrow. Meaning how to make the date in cell B1 to be constant or fixed or what to call it.


    Thank you in advarce for the help.
    Alring

    Re: Constant Date


    It looks like you want to record the date in B1 when contain of A1 is changed.
    You would need a macro:[hr]*[/hr] Auto Merged Post Until 24 Hrs Passes;[dl]*[/dl]It looks like you want to record the date in B1 when contain of A1 is changed.
    You would need a macro:
    Auto_Open: to record previous A1 value
    to change B1 when A1 has been changed
    Perhaps file attached could help

    Re: Constant Date In Adjacent Cell On Enter


    Thank you PCI for your reply. It's working but I was hoping that it was possible to make it in a formula and not in VBA.


    Any way thank you for your help.


    Regards Alring

    Re: Constant Date In Adjacent Cell On Enter


    Hi Alring,


    You cant do what you are trying to do with Formulas, you will need some form of VBA.


    =TODAY()


    is a volatile function.


    A Volatile Function in a formula in a cell makes that cell be always recalculated at each recalculation even if it does not appear to have any changed precedents.


    So everytime the sheet recalulates (which happens everytime the sheet is opened), the function is evaluated and a new date is put into the cell.


    There is a few ways around this, but all involve VBA...


    Ger

    _______________________________________________
    There are 10 types of people in the world. Those that understand Binary and those that dont. :P


    Why are Halloween and Christmas the same? Because Oct 31 = Dec 25... ;)

    _______________________________________________

    Re: Constant Date In Adjacent Cell On Enter


    Hi There


    Thank you for your help. It seems that I have to use VBA to make it work. I don't like that but that's not your fall.


    Anyway thank you for your help.


    Best regards
    Alring

    Re: Constant Date In Adjacent Cell On Enter


    Hi Dave


    I'm not sure what you mean but as I understand it then I can overrule that Excel write a new date (in cell B1) the day after when the document is opened again. But I don't know how many times the document have to open. As i understand you then I have to use VBA.


    Best Regards
    Alring

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login