Hi, Hope this is what you require
Date Stamp =IF(ISBLANK(A2),"",IF(B2="",TODAY(),B2))
An entry into A2 will put today's date into B2, when the next day arrives,
The date will not change. Any problems Repost or email me.
Paul


On 15/11/05 11:16 PM, in article
, "TimM"
wrote:

Yesterday I posted a question about auto filling the date in a field (posted
bellow). Well today to my dismay all those dates advanced to todays date. Is
there another formula that can be used to auto fill in the date and not
advance to the next days date when the sheet is reopened. Also Hope fully
some one will be able to answer the rest of my second question asked
yesterday (also posted below).

By the way '=IF(OR(E2={1,2,3}),TODAY(),"")' works great (except for the
advancing of the date thing mentioned above) I would of never been able to
come up with such a formula on my own.