How to Add Timestamp in Excel

If you are working or using an Excel tracker, it would be good to have a timestamp for every record that you are entering. Having this extra field on your tracker will surely help you track progress of a certain record whether on which date and time you enter the record in the system as well as if there are any status change.

You may probably think of doing this in VBA, but you might don’t know where to start. If you’re not into VBA programming, you may end up not to include this critical field anymore.

There’s an easier way to do this using a combination of different functions and of course, Nested If. In this video tutorial, I will explain how this formula works. Please watch until the very end of this video.

Download practice file:

“People do not decide to become extraordinary. They decide to accomplish extraordinary things.”
— Edmund Hillary

*************************************************
Want to learn more about Excel?

SUBSCRIBE NOW:

YouTube Playlist:

See you there!

Romeo Costillas
Microsoft Certified Solutions Associate BI Reporting
Microsoft Office Specialist Master
Microsoft Office Specialist Excel Expert
Microsoft Innovative Educator
Discrete Event Simulation Modeler

Tagalog Excel | Filipino | Pinoy Excel | Excel Tagalog Tutorial | Paano Gamitin ang Excel

#excelbyromeocostillas #Excel #ExcelTips #excelpinoy

[jackgates]

Yours is the only one that works!!!! Thank you!!😊

[antoniog]

Thank you! This helped me to understand. Great explanations of each portions and why. You're an excellent teacher.

[rakeshrajpal]

It works when we update values manually or by a drop-down but How to make it work when Values are updated with formula...it is not updating, Kindly suggest a vba if cannot be done by the formula method.

[Abc-hezw]

Can we apply this formula on two cells like we have three cells and when we add data in any of the first two cells the date automatically add in the third cell
Plz reply I am very confused and it is very important for me