+ Reply to Thread
Results 1 to 2 of 2

Posting TODAY's date when entering info in a log?

Hybrid View

  1. #1
    Registered User
    Join Date
    01-24-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1

    Posting TODAY's date when entering info in a log?

    Hi am making a spreadsheet that logs issues in a specific project.
    When the user logs an event. I would like for excel to input the date that the person logged the information into the spreadsheet.
    Currently my formula utilizes the TODAY function but I realized that the date will continue to update to the present date. I would like to log a date when data is entered into a cell, and that date will not update to present time.
    Below is an example of my formula i have currently.


    Cell H2: Formula: =IF(I2=2,TODAY(),XX)
    Cell I2= TYPE(K2)(this cell is hidden to the user) Type displays number 2 when text is the value of the referenced cell.
    Cell K2= User Data log info.

    I would like to change H2's formula to a date that will not update to the present date.
    Thanks

  2. #2
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Posting TODAY's date when entering info in a log?

    Here's the way to do this.

    http://www.mcgimpsey.com/excel/timestamp.html
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1