Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Perfect Thanks for all the help.
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.
![](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)
Anonymous
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.
Microsoft 365 and Office | Excel | For home | Windows
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.
10 answers
Sort by: Oldest
-
Deleted
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
-
Deleted
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
-
Anonymous
2016-07-26T19:04:04+00:00 -
Anonymous
2016-10-25T01:39:41+00:00 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.
-
Deleted
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