Forum Discussion

vijay m's avatar
vijay m
Copper Contributor
Feb 14, 2018

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

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver 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 Lau's avatar
      Willy Lau
      Steel 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 Lau's avatar
    Willy Lau
    Steel Contributor
    Formula is to provide dynamic data. You may need a vba solution.

Resources