Create A Timestamp In Excel With A Formula

Learn how to enter an automatic date and timestamp into an Excel worksheet.

This Excel tip walks you through how to use a circular reference in Excel to date and timestamp cells in Column B when an entry is made into cells in Column A.

SUBSCRIBE TO THE EXCEL AT EXCEL NEWSLETTER - 3 FREE Excel Tips First Wednesday of EVERY month. Join US! Click the link below

Be Social & Let's Connect

[AANDYG]

This is the single greatest tutorial I have ever come across. So clear and concise, explaining every step of the way and what it all means.

Thank you so much! Subscribed and I hope to learn much more from watching the channel!

[CliveLoseby]

Thank you! This is so perfect for me! I have been using Excel for 20 years but never knew this could be done so easily! Fab!

[mwitalemi]

i have watched so many videos, finally found this that not only gave the right answer, but EXPLAINED how you got to the answer. thank you thank you thank you.

[jamesperry]

Never watched a video like this before. Super trick on circular reference. THANK YOU.

[Jashi_Kholin]

Thank you so much! I've been doing so much research, and all I could find were videos inputting VBA formulas. I'm not that skilled. This is so much simpler!

[usmanyousaf]

Thank you so much really exactly what I want ❤appreciate you this is my first comment on youtube

[bobbysamelak-pain]

Thank you - your formula and reference to enabling iterative calculations was very helpful. Most other tutorials omitted the iterative calculation part and I was banging my head against a brick wall as to why this was happening.

[jmburk]

I love that you explain what the symbols are telling Excel to do. Very well done, thank you.

[atps]

Great, great, great. Just what I needed. I am going to use it to create automatic timestamps for online excel surveys. Thank you for the amazing tutorial.

[alexvwes]

Great video! Really helpful no nonsens and clear. Thanks a lot!

[kevinf]

This actually does work. Thanks a bunch.

[jeanmariemcfadden]

Big thumbs up for this. Works in Google Sheets as well.

[Suthrndlt]

I love this handy little tip and just put it into use. However, trying to find where to sign up for your newsletter is frustrating. Is there a direct link to sign up, and if not, where on the Learn to Excel at Excel website can I find it among all of the ads and tips? Thanks so much for all that you do! I found the spot to sign up, however, I get a 404 error.

[hdjdjdsdeeee]

Thank you for saving my lot of time. You are doing great.

[ulyssesemmanuel]

Thanks a lot. This is what I was looking for.

[zugzvang]

Big Thanks for this well made content!

[wayneedmondson]

Nice.. cool trick.. always did this with VBA. Never thought about using a formula. Thanks for the insights. Thumbs up!

[raitahedley]

Thanks for your help! Very concise and informative. :D

[MTLYF]

that was exactly what i have been looking for. thank you very much

[AshokKumar-hdpz]

I am great fan of yours and learned lot of excel formulas by seeing your vedios.

Now i need a help hope you would help me in our office we have a daily tracker in that we have 12 agents and works in 24/7 shifts we work on incident tickets.
We are team of 10 agents and as soon as the ticket arrives we have to enter the ticket number in that sheet under the agent name and change the color of the cell manually according to the time the ticket arrived.
for eg. if ticket came in between 8am to 9 am it will be green if it is between 9 am to 10 am then red if it is between 10 am to 11 am then purple so on so instead of changing the color manually i need a formula or a steps so based on current time when the data entered into a cell the color should change please suggest


Thanks,
Ashok Kumar B.N