Auto Date in a cell-

[thursday140]

I was wondering if there's a formula that would automatically update a cell with the current date as you enter data in a different cell.

Example: Cell A1 i would enter "order placed", then in B1 it will display the date I entered the data.

Thank you,

[mehmetcik]

Formula for B1

Please Login or Register  to view this content.

A better solution is a macro.

Right click on your sheet name at the bottom of excel and select view code.

Paste this code in the window that opens. then close the window.

Please Login or Register  to view this content.

[ChemistB]

This is something you would typically do with VBA.
Assuming you will be entering data in A2:A1000 and you want Col B to contain the date.
Right click on the sheet tab and "View Code". Paste this code into the text box

Please Login or Register  to view this content.

Does that work for you?

[thursday140]

Thank you so very much for the response-

The VBA code is awesome! However what if I wanted the date to show on a different column as oppose to column B say I wanted the date to be in column J. What then?

[ChemistB]

The offset line of code is what is determining the column. B is one offset from A (where you are entering data) so J is offset 9. Replace 1 with 9.

[thursday140]

Thank you all!