Automatically Add Date/Time to a Cell When You Enter || Record Date and Time when Value is Changed

We know that by using the functions Today() and Now() in Excel, we get the current Date and Time but these values will not be static and keep on updating on saving your workbook.

But if we need to get a static date into a cell after data is entered into other cells.

Best Laptops to use for better speed:

Here is the solution, watch this video to know this trick.

Let’s suppose when data is entered in column A, we want to have the corresponding current dates into column B in the same row.

Follow the steps now to perform

And paste into this VBA window.

Exit this VBA window and go back to the Excel workbook

Now, let us test it by adding any data to any cell in the range A1:A1000.
You will see the current date appearing in the corresponding cell in column B.
It is awesome right

That’s all friends, as part of today’s Excel tricks.

Our Recommendations
***************************************************************

If you found this video valuable, give it a like. If you know someone who needs to see it, share it. Leave a comment below with your thoughts. Add it to a playlist if you want to watch it later.

***********************************************

⚡️Tools for YouTube vlogging:
***********************************************
***********************************************

⚡️You Can Connect with Me at:
***********************************************

#dptutorials #Exceltraining #ExcelTricks #ExcelTips #ExcelFreeTraining #ExcelFreeLearning

⚡️Tags: -
excel formulas in English, excel in English, excel tutorial in English,ms excel in english,ms excel tutorial in English, learn excel in English,vlookup in excel in English, learn ms excel in English, excel training, excel tutorial, Microsoft Excel 2007, learn excel,tutorial excel, ms excel tutorial, excel tutorials,ms excel 2007,Microsoft Excel training,learn excel online,learning excel,free excel training,online excel training,advanced excel tutorial,excel tutorial, excel formulas and functions, excel formulas, excel tutorial in Hindi, excel formulas and functions in Hindi, excel tricks, excel in Hindi, excel shortcut keys, excel vlookup, excel formulas in Hindi, excel for beginners, excel for accounting, excel formulas and functions tutorial, Excel Sum Formula, Sum Formula series, excel attendance sheet, excel salary sheet, excel stock maintain, excel data entry, advanced excel tutorial,excel formulas,excel tutorial,vlookup excel,excel accounting,excel for beginners,excel shortcut keys,excel sum formula,excel training,excel training online,excel tricks,free excel training,learn excel,learn excel online,microsoft excel training

⚡️Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

[rayaneelmedawar]

THANK YOU, you're a life saver!

If anyone wants their date to be inserted into column E for example, so that is column number 5, then change the code to
If Not Intersect(Target, Range("B1:B1000")) Is Nothing Then
With Target(1, 4)

[paaszczaktaxi]

Very good job!
I was looking for this solution for hours!
God bless you!

[gregdileo]

That was a tremendous time saver!!! Thank you

[ankurpatel]

Hello, Thank you very much for this video. It really helped me. One thing I have is "How can I lock the cells once the date and time are entered? " Really appreciate your help with this.

[nandanlawande]

Thank you for the VBA code, it works perfectly. Just another question though, when i delete the cell which was manually updated for e.g. cells in column A, the date is still shown in the cells. Is it possible to clear the date as well when we clear the value of cells in column A? or does the deletion is considered an action and so the date will always be there unless removed manually?
TIA

[wolfeburton]

This Worked Great! Thanks, I did run into a problem with wanted to enter data in colun I and have the date show in column J. I first changed the 1, 2 to 1, 10 and the date showed up in the right spot. But I hadn't changed the A1:A1000 yet. When I changed that to I1:I1000 I didnt see the date. I then realized that i had to go back to change the 1, 10 back to 1, 2 and it worked. Thanks Again!

[dhavalgorasia]

What if I want the same function on multiple columns like I have a table where I record purchase orders in B1 (this can be down with the VBA code you have shared) but I want to record the "out of stock" date as well which would be in F1. Is there any workaround for that?

[shaneraines]

Excellent explanation very clear and works! Thank you.

[cyndifick]

What changes do I need to make to the Macro if I want to record the date in column I for changes made to column H?

[brijeshashukla]

Dear Sir, Thank very much. Very nice ever have across. It working fine.

[greatthinking]

thank you so much buddy for that I wish te best

[DrLusEnglish]

You saved me some time. So thank you very much for your work.

[testdelete]

Is the anyway to make this work when a specific text is into the cell by formula?

I have;

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Intersect(Target, Range("X1:X1000")).Value = "Sent" Then
With Target(1, 10)
.Value = Date
.EntireColumn.AutoFit
End With
End If
End Sub



But I get Run error 91. Could you let me know how to correct please my friend?

[SlightlyVertigo]

Hello. Is there a way to modify this code, to only enter the date if the Cell next to it has the text Yes in it? For example Column 1 - Resolved Y/N, Column 2 - Date Resolved

[AshokKumar-hdpz]

Hello DPtutorials - i need help we have a excel which is used as daily ticket tracker team enter the ticket based on the time the ticket arrived and changed the color for e.g. if the ticket arrived between 8 am to 9 am it is marked in green and the ticket which come between 9 am to 10 am it is in red like me every one hour the color changes and this file worked 24/7 so any formula to change the cell color based on the data entered in a cell on specific time

[jagadishchandramaroju]

Thanks my friend, its Fantastic working fine, can we do same thing in google sheets ?

[RakeshnarayanJha]

Great Video :) Thanks for uploading!! It was indeed helpful and created an assignment within couple of hours after watching this video...
One Question: If cells (Start, End and Total time) are locked, the function does not work. Do we have a solution to it.

[chapniemnhatsinh]

Thank you so much for sharing with us... but I have a question... that if i have a data in column B to Z. And I want to show the result in column A, and have more condition.
Example: My data is from B1 to Z100, and if I change one of data in B1, the time in A1 have changed too. But if B1 have new update, and need me to accept, that A1 just update new time kha.
Can you help me this one kha. Thank you so much.

[annemarieworp]

Hi! Thanks for the video. I want to secure the date/time cel now for changing it. So when they need to fill in cell 1, cell 2 is giving the time from filling it in. Do you know how to do that? When I secure cell 2 is the macro not working anymore..

[Dreadnought]

i have a simuler code but doesn't seem to work if i wanted to do it in multiple collums. example: Collum "A": auto-Date/time, Cullum "B": information1, Collum "C": Information 2, Collum "D" blank, Collum "E" an other Auto-Date/time. I've tried by creating a seperate coding page and i've tried by just creating a 2nd line for the second set of ranges. but neither seems to work. any chance you could help me fix that? Data must be next to each other. Only the last set of ranges work unless i comment either one of the sets out