Since I'll be posting this as a shared workbook on SharePoint, I'm hoping there's a method to do this using a formula.

Tasks are listed in Column B, and the Assignment Date and Time are listed in Column E. Is there a formula that, each time data is entered into column B, would automatically enter the current date and time in column E?
Dec 10, 2022 in Others 73 views

## 1 answer to this question.

Here's how to accomplish things in another method. Iterative calculations should first be enabled by going to File - Options - Formulas - Enable Iterative Calculation. set the maximum number of iterations to 1000.

Although the 1000 iterations are not necessary for this calculation, they do prevent Excel from becoming trapped in an endless loop when using other circular references.

Use the following formula after completing this.

```=If(D55="","",IF(C55="",NOW(),C55))
```

When text is entered into cell D55 (in this example), cell C55 populates with the current date and/or time, depending on the format of the cell. This date and time will remain the same even if fresh information is added to cell C55, so it displays the time and date at which the data was initially entered.

Every time you open the worksheet, you will be warned that this formula uses a circular reference, so be aware of that. Whatever the case, the formula is accurate and simple to use anywhere in the worksheet.

• 53,920 points

## What is the formula to keep first two words in a cell over excel?

I want to maintain the first two ...READ MORE

## What is the shortest formula in excel to covert text date format e.g. 17 Jan, 2023 into regular date format like 1/17/2023?

The SUBSTITUTE() method can be used to ...READ MORE

## How do I combine the first character of a cell with another cell in Excel?

Try this: =CONCATENATE(LEFT(A1,1), B1) READ MORE

## MS Excel showing the formula in a cell instead of the resulting value

Make sure that... There's an = sign before the formula There's ...READ MORE

## Excel formula for searching two text in one cell and return values based on the result

You can include a second IF within ...READ MORE

## What is the character code for new line break in excel

Use CHAR(10) and Turn on Wrap Text option. It ...READ MORE

## Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE