+ Reply to Thread
Results 1 to 8 of 8

Possible to have cell return date and/or time another cell was first edited/written t

  1. #1
    Forum Contributor juntjoo's Avatar
    Join Date
    02-29-2008
    Location
    Cape Coral, FL
    MS-Off Ver
    Excel 2010 14.04.4760.1000
    Posts
    442

    Possible to have cell return date and/or time another cell was first edited/written t

    I'd like my rows of info have a time stamp of when they were created, based on a particular cell I imagine how this would work if possible. Like the cell in column B it would equal/output the first time the cell in column A was first edited. Thanks

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX & Windows
    Posts
    7,234

    Re: Possible to have cell return date and/or time another cell was first edited/written t

    have a read here on how to setup a timestamp
    http://www.howtoexcelatexcel.com/exc...with-formulas/
    http://chandoo.org/wp/2009/01/08/tim...-formula-help/
    Wayne

    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Forum Contributor juntjoo's Avatar
    Join Date
    02-29-2008
    Location
    Cape Coral, FL
    MS-Off Ver
    Excel 2010 14.04.4760.1000
    Posts
    442
    Quote Originally Posted by etaf View Post
    Thank you. So far looks to work. That's one to study. Nested if then statements K me O.
    Excel 1.0.1 (16.0.14326.20140) (Android)
    Excel 2010 14.04.4760.1000

  4. #4
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX & Windows
    Posts
    7,234

    Re: Possible to have cell return date and/or time another cell was first edited/written t

    you are welcome
    if my assistance has helped, and only if you wish to , there is a reputation icon * on the left hand side - you can add to my reputation here

  5. #5
    Forum Contributor juntjoo's Avatar
    Join Date
    02-29-2008
    Location
    Cape Coral, FL
    MS-Off Ver
    Excel 2010 14.04.4760.1000
    Posts
    442

    Re: Possible to have cell return date and/or time another cell was first edited/written t

    Thanks. Check this out tho:

    http://www.excelforum.com/showthread...=1#post4417825

    my sample file on this page in the 3rd post on the left you can see how I've successfully implemented this formula to return a date when the subject cell had first been edited(today) but when I tried to insert it into the table below(ignore how after pasting the data over from my original file the table disappeared since the formulas and issues remained) the results give you that erroneous 1900 date. Any idea what happened there?

  6. #6
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX & Windows
    Posts
    7,234

    Re: Possible to have cell return date and/or time another cell was first edited/written t

    confused - you have two posts running now

  7. #7
    Forum Contributor juntjoo's Avatar
    Join Date
    02-29-2008
    Location
    Cape Coral, FL
    MS-Off Ver
    Excel 2010 14.04.4760.1000
    Posts
    442
    Quote Originally Posted by etaf View Post
    confused - you have two posts running now
    Yes but dealing with two different issues but I'm using a common file to show both issues

  8. #8
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,637

    Re: Possible to have cell return date and/or time another cell was first edited/written t

    your formula in C7
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    will always return C7 (if I7 is not blank)....zero which in date format is 0/01/1900

    why dont you just get rid of the 2nd IF statement?
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    also i note your using NOW instead of TODAY
    just note now affixes the time as well
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 09-16-2014, 07:59 AM
  2. Show date/time of when cell/column was last edited?
    By Bwangster12 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-24-2013, 03:01 AM
  3. Insert automatic date and time stamp in a cell if any cell of the same row is edited
    By kdhanerawala in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 11-12-2012, 06:18 PM
  4. [SOLVED] Return output from written results in different cell
    By jana135 in forum Excel General
    Replies: 6
    Last Post: 07-03-2012, 03:12 AM
  5. Return output from written results in different cell
    By jana135 in forum Excel General
    Replies: 1
    Last Post: 07-03-2012, 12:55 AM
  6. [SOLVED] Show time cell last edited
    By adamsurpren in forum Excel General
    Replies: 3
    Last Post: 06-13-2012, 02:02 PM
  7. Replies: 1
    Last Post: 06-09-2010, 01:05 PM

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