How to Automatically Enter Date & Time After Data Entry In Excel

How to Automatically Enter Date & Time After Data Entry in Excel?
Excel is mostly used for daily calculations, and for those calculations, we need to enter tons of data every day in excel. It becomes tiresome to enter the current timestamp every time you enter data in excel. Also, what if I want the date to update in excel automatically? Doing this manually is not only tough but also prone to error.

I have covered several videos on this, here goes the links:

In this video, I'll cover how to add a current timestamp in excel using excel formulas. I've created some excellent formulas using excel date functions to insert the current date and time in a cell and also auto-update date & time whenever you edit a cell in excel. I'm using Excel 2019 for the demonstration, and let's follow the instructions to enter date when data entered in a column automatically.

Step 1: Click on the File Tab
Step 2: Click on Options
Step 3: Click on Formulas
Step 4: Checkmark "Enable Iterative Calculation"
Step 5: Click ok and select the cell (B1) where you want the current timestamp
Step 7: Drag the formula to autofill the formula in excel
Step 8: Select the columns and right-click & Select Format Cells to change the date format
Step 9: Select Custom and Select your Prefeed timestamp format
Step 10: Enter the data in cell A1 and date & time will be automatically added to cell B1
This is how you command excel to automatically enter the date when data entered in another cell using formula. Now, what if you need to auto-update excel timestamp when a cell is changed?
This is how you can automatically enter the date when data is entered in a column in excel and also update it when the data is changed.
#Auto #Timestamp

Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial

Here goes the most recent video of the channel:

Playlists:

Social media:

[thomaswightman]

I tried so many other (more complicated) ways to do this from YouTube video without success, then I found this method that was so much simpler than the others; and it WORKED !!! Thank you for posting this solution.

[starlightmitsurugi]

Thanks for the formula 😉. It takes me some time to adjust some cells since I'm using Android excel as beginner. This is effective so far on Android because havent interactive calculation settings on Microsoft office but has circular sign

[jarremaemalaga]

Thank you for sharing your knowledge ☺️

[myatmyintmo]

Thanks alot.I consider it about two days.

[bunlong]

I am looking for a long time ago. Now I see it Thanks

[TheRicardo]

Amazing, I have some skills but not at this level, your formula is fantastic to add on my project.

[MyRobin]

Omg, Just what I needed for my class register !! Thanks Sir.

[kunaalbhagat]

Exactly what I needed! Thank you sir :)

[LutfulAmin]

Thanks for showing an interesting formula which I did not know.

[kabirrana]

Thank you so much, now i saved lots of time 👌

[nemanjajovanovic]

Does it work in google spreadsheets? What's the formula for it? I would need both formulas, the one that does not change and the other one that updates automatically, can you please help?

[eangkheangj]

Hello Sir ! many thanks for the formula, it is really helpful. However, the formula also automatically updates the date even i have not made any edits to the data entries and just pressing save. Are there any solutions for that, sir?

[yafedxiong]

Great video and this formula will greatly help me out big time. How do I get the formula?

[mrzkuness]

Thank you for information How can I use formula on mobile !

[DanielTorres-pxgr]

Hello! I followed exactly how you had the first formula and it did not work. It gave me 1/0/1900 0:00 ... what did I do wrong? I formatted the cells exactly and did the iteration as well

[mdmurshadulalaminternation]

Hello Sir, It is an excellent video. you are requested to insert the formulas in this video link.

[sandeepreddy]

Awesome video Sir but when a value is deleted timestamp also gets delete is there a formula so that timestamp doesnt gets remove even though value is deleted in a cell

[marybellandry]

Love this! Very helpful and hoping this works as my team and I update our file.

[barneyDcaller]

Why is it the date changes everytime you open the file on another day? Like when you created a file on jan 22, then when you open the file again on apr 3, it will show apr 3 and not jan 22? Any formula to fix this?