LinkBack URL
About LinkBacks
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
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
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.
Thank you. So far looks to work. That's one to study. Nested if then statements K me O.Originally Posted by etaf
Excel 1.0.1 (16.0.14326.20140) (Android)
Excel 2010 14.04.4760.1000
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
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?
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
your formula in C7
Formula:
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: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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks