NOW Function in Excel: How to Display the Current Date and Time

6 Mar, 2023
paresh
Paresh @Boloforms
1 min read
BoloForms

Create a free BoloForms account today!

Create your free account today and start creating your own digital signature.

Create Free Account

Excel is a powerful spreadsheet program that can be used to perform calculations and analyze data. One of the many features available in Excel is the NOW function, which can be used to display the current date and time.

The NOW function can be used to display the current date and time as either text or numerical values. To use the NOW function, you simply need to type =NOW() into the cell where you want the date and time to be displayed. This will return the current date and time as both a date value (in the format mm/dd/yyyy) and a time value (in the format hh:mm:ss).

You can also use the NOW function to calculate the elapsed time between two dates or times. For example, if you have a list of dates and need to calculate the number of days between them, you can use the formula =NOW()-[date]. The result will be displayed as the number of days between the current date and the specified date.

In short, the NOW function is a useful tool for displaying the current date and time in Excel. It can also be used to calculate the elapsed time between two dates or times, making it a great way to quickly analyze data and keep track of important information.

Limited-time offer
Get lifetime access to BoloForms Signatures for FREE!
Includes :
Collect Signatures inside Forms (5 submissions/mo)
Send for Signature (1 document/mo)
5 Forms- Generate Custom PDFs based on Form Submissions
1 PDF Template
Free Contracts Templates
24/7 support
Notifications and Reminders
Audit Log and History
BoloForms Signature Branding

(act fast as this exclusive offer won't last forever!)

Free Forever
No credit card required