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:
https://docs.google.com/spreadsheets/d/1ozBtTizM3sUDiXFqRJut5v_R_HZIDz5b/edit?usp=sharing&ouid=100903074917812002291&rtpof=true&sd=true

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

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

SUBSCRIBE NOW:
https://www.youtube.com/channel/UCqGtUgcTs7Ml3ZliCqUo-3Q?view_as=subscriber?sub_confirmation=1

YouTube Playlist:
https://www.youtube.com/watch?v=QprmWzbyFJo&list=PL6u1_VTMTuroJ2vYazClV476kTJHb4Gyb

Or visit me on Facebook at https://www.facebook.com/ExcelbyRomeoCostillas

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

Please take the opportunity to connect and share this video with your friends and family if you find it useful.