当在同一行的另一个单元格中输入数据时,Excel公式将日期/时间放在单元格中 [英] Excel Formula which places date/time in cell when data is entered in another cell in the same row
问题描述
有没有一个公式会自动输入列E中的当前日期和时间,只要有人将数据输入列B?
任何帮助将不胜感激。
下面描述另一种方法。
首先,打开迭代下的计算文件 - 选项 - 公式 - 启用迭代计算
。然后将最大迭代设置为1000。
执行此操作后,请使用以下公式。
code> = If(D55 =,,IF(C55 =,NOW(),C55))
一旦任何东西输入到单元格 D55
(此例中),则 C55
填充今天的日期和/或时间取决于单元格格式。即使将新数据输入到单元格C55中,以显示最初输入数据的日期/时间,此日期/时间也不会再次更改。
这是一个循环参考公式,以便您每次打开工作簿时都会收到一条警告。无论如何,该公式可以在工作表中任何地方轻松使用。
Hoping there is a way this can be done with a formula since I will be putting this on SharePoint as a shared workbook.
Column B contains Tasks, while Column E contains the Date and Time of when the Task was assigned. Is there a formula that would automatically enter the current date and time in Column E whenever someone entered data into column B?
Any assistance would be greatly appreciated.
Another way to do this is described below.
First, turn on iterative calculations on under File - Options - Formulas - Enable Iterative Calculation
. Then set maximum iterations to 1000.
After doing this, use the following formula.
=If(D55="","",IF(C55="",NOW(),C55))
Once anything is typed into cell D55
(for this example) then C55
populates today's date and/or time depending on the cell format. This date/time will not change again even if new data is entered into cell C55 so it shows the date/time that the data was entered originally.
This is a circular reference formula so you will get a warning about it every time you open the workbook. Regardless, the formula works and is easy to use anywhere you would like in the worksheet.
这篇关于当在同一行的另一个单元格中输入数据时,Excel公式将日期/时间放在单元格中的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!