Forum Discussion
vijay m
Feb 14, 2018Copper Contributor
Excel Date
hi when i enter data in first column i would like to record the data of data entered in first column in a different column.
i have written if(cellin1stcolumn<>"",today(),"")
this one is creating date but the date is changing everyday. i want the date to remain once i entered data in first column please help
3 Replies
Sort By
- Haytham AmairahSilver Contributor
Hi,
I don't think this is possible using formulas, and the VBA solution may not be efficient!
When you enter the data in the first column, go to the second column and press Ctrl+; (Ctrl+Semi-Colon) which is the keyboard shortcut to enter the today's date as a constant date!
This is the most efficient and effective way!
- Willy LauSteel Contributor
It depends if automation is required. If not, I agree with Haytham because no option is more efficient than directly input the value with shortcut key.
- Willy LauSteel ContributorFormula is to provide dynamic data. You may need a vba solution.