Forum Discussion
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 ...
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!
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.