Download the featured file here: https://www.bluepecantraining.com/aut...

In this video I demonstrate how to date and time stamp your data entry. The NOW() function can be used to return the current date and time but this will change whenever the worksheet is edited. We want the date and time stamp to be fixed. There are two methods I demonstrate for achieving this: the first uses a formula and the second uses a VBA macro. The VBA macro solution also displays when the data was last modified.

Table of Contents:

00:00 Introduction
00:52 Formula method for creating a date and time stamp that doesn't change
04:04 Use a VBA macro to create a date and time stamp