Microsoft Excel

Excel NOW Function | Excel One Minute Quick Reference

Chris Menard

Chris Menard

— 1 min read
Excel NOW Function | Excel One Minute Quick Reference

The **NOW** function in Excel returns the current date and time. The NOW function is useful when you need to display the current date and time on a worksheet or calculate a value based on the current date and time, and have that value updated each time you open the worksheet.

If the cell format was General before the function was entered, Excel changes the cell format so that it matches the date and time format of your regional settings. You can change the date and time format for the cell by using the commands in the Number group of the Home tab on the Ribbon.

NOW function in Excel

NOW function in Excel

YouTube video

Excel NOW Function | Excel One Minute Functions Explained

Syntax for NOW

=NOW()

The NOW function syntax has no arguments.

Read more