Static Date

[Patricks7]

I want to create a formula that will create a static date. for example
=if(a1="c",today(),0) Is it possible to have that date stay the same even though it says today and will change automatically the following days?

 

[DonkeyOte]

You could use a circular reference, however, these are generally ill advised - for sake of demo. assuming B1 is to contain the formula driven date:

=IF(A1<>"c",0,IF(B1,B1,TODAY()))
custom format to mask 0: dd-mmm-yy;;;

The above would insert a date when A1 is altered to "c" thereafter it would remain static until such time as A1 was altered. Were "c" subsequently reinstated to A1 then the live date would be added back to B1.

If you wish to test the above you can use NOW() in place of TODAY() - format as hh:mm:ss to see how the value persists.

If you prefer to avoid circular calculations you might consider using VBA (Change Event).

 

[Patricks7]

Thank you, I will try it. What I'm trying to accomplish is the same as pushing control + semi colon to create a permanent date but using an if( statement.
Thanks again