Excel Formula which places date time in cell when data is entered in another cell in the same row

0 votes
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 by Kithuzzz
• 29,080 points
73 views

1 answer to this question.

0 votes

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.

answered Dec 11, 2022 by narikkadan
• 53,920 points

Related Questions In Others

0 votes
0 answers

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

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

Nov 2, 2022 in Others by Kithuzzz
• 29,080 points
63 views
0 votes
1 answer

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

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

answered Nov 7, 2022 in Others by narikkadan
• 53,920 points
105 views
0 votes
1 answer

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

answered Nov 8, 2022 in Others by narikkadan
• 53,920 points
134 views
0 votes
1 answer

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

answered Oct 10, 2022 in Others by narikkadan
• 53,920 points
208 views
0 votes
1 answer

What is the character code for new line break in excel

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

answered Dec 27, 2022 in Others by narikkadan
• 53,920 points
65 views
0 votes
1 answer

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

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,630 points
215 views
0 votes
1 answer

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

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

answered Feb 16, 2022 in Others by Edureka
• 13,630 points
395 views
0 votes
1 answer
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP