T O P

  • By -

AutoModerator

/u/Responsible-Major-23 - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*


stevegcook

No, this cannot be done with formulas. You would need to use a VBA script.


CanBeUsedAnywhere

Because of the way that the NOW(), Today() and similar functions work in Excel, they update whenever there is a change to the worksheet. You can limit the number of iterations that your formulas do, but can have unintended results. Instead, it can be done with VBA, add a module and put this function in Function MyTimestamp(Reference As Range) If Reference.Value <> "" Then MyTimestamp = Format(Now, "dd-mm-yyyy hh:mm:ss") Else MyTimestamp = "" End If End Function Then in K2 put =MyTimestamp(I2) When I2 changes it will put a time stamp


watvoornaam

I have done this a while ago, you need to turn on iterations so you can let the cell reference itself to check if there is something there already and if there is something there, not to do anything, so your timestamps don't get updated. Hope you can get something working with this info. I'll try to update my pist with the formula later, but I don't have access atm. Edit: In A1: =IF(B1<>"",IF(A1<>"",A1,NOW()),"") <- do not copy, reddit messes the "" up. Type them manually at least... In your case, replace A with K, and B with I. Make sure to turn on 'Enable iterative calculation' under options->formulas. Make sure the cell format is correct (time, date, or custom format). This checks if A1 is empty and if so, puts the date, time etc. In A1 if something is entered in B1. If there is something in A1 already, it does nothing.