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...


Bill Jelen is the author / co-author of
Microsoft Excel 2019 Pivot Table Data Crunching

Use Excel 2019 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours, to take control of your data and your business. Even if you’ve never created a pivot table before, this book will help you leverage all their remarkable flexibility and analytical power–including valuable improvements in Excel 2019 and Excel in Office 365.