Thread: Date stamp when a value is entered in a cell
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sloth Sloth is offline
external usenet poster
  
Posts: 252
Default Date stamp when a value is entered in a cell
You will first need to goto Tools-Options-Calculations Tab, and check the
"iteration" checkbox (this tells Excell to allow circular references). Then
input the following formula.

=IF(Joe!H4=1,IF(A1="",NOW(),A1),"")

Replace A1 with the cell the formula is in so that it refers to itself.
Reply With QuoteReply With Quote