This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Autofill date when another cell is filled in (not blank) but need the cell to stay blank and not update when the file is opened the next day. Using cells V1 and O1, in cell O1 I have =IF(A1<>"",TODAY(),"") but the date always changes when I need it to remain the date the data was entered into V1. Any ideas?
Sorry I initially put A1 & A2 instead of V1 and O1, and I need to make it so when data is entered in column V the date the data was entered displays in column O. Hope this doesn't make the solution too complicated.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more
How do I add AllowFormattingCells in this code? When data is entered using the form and the date is autofilled the box to allow formatting (highlighting) is unchecked and users can't highlight data.
Perfect Thanks for all the help.
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more