MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Automatically Get the Date and Time

October 15, 2001 - by Bill Jelen

Ricardo asked:

Is there a way to get the date and time automatically by creating a formula?

This is an easy one - use =NOW() to get the current date and time. Use =TODAY() to get the current date.

There you have it, weblog entry #3. The downside is that information here will be in a totally random LIFO sequence - one day it may be simple functions, the next day it may be VBA. Add this page to your favorites, check back a every couple of days and let's see if anything interesting develops from this new technology.

Until tomorrow...