Create a number that increases by 1 each day starting from zero

[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

 

[DonkeyOte]

duplicate:

http://www.mrexcel.com/forum/showthread.php?t=574845

 

[VoG]

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).