Automatically Insert Current Time and Date in a Worksheet

If you want to display the current time and date in excel automatically, then just use this formula:

=Now()

This will return the current date and time in the format that you set in your windows preferences. If, on the other hand, you only want to see the date, then just use this formula:

=Today()


Here is a sample output of each formula:

Now()   : 5/21/2011 12:41
Today() : 5/21/2011



Happy Computing!

Tweet