Is there a formula in which TODAY will not auto update. Let's say I want "2/20/2017" to stay as "2/20/2017" and the following day it wont change to "2/21/2017"?.. Because here is what im trying to do. Once you put an entry to A2 cell, it will automatically put a date on B2 cell. However when I used today on b2 cell which is "2/20/2017" yesterday, it will change to "2/21/2017" which is today. What I want is for B2 cell to stay as "2/20/217" and not change to "2/21/2017" the following day. Is that possible?