• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Now Function in Excel

April 8, 2021 by Andrew Childress
Now function Excel

Ever wanted to insert the date and time in your spreadsheet? Let’s learn how to use the NOW function in Microsoft Excel with these easy steps.

Ever wanted to insert the date and time in your spreadsheet? There’s a function for that! Let’ s learn how to use the NOW function in Microsoft Excel.

How to Use the NOW Function in Excel (Current Details)

Sometimes, it’s useful to have the current date and time included on your Excel spreadsheets. You could always type this manually. However, doing that won’t update itself. Any text you input will remain static. If you want the date and time to update, you should use Excel’s NOW function.

Consider an empty cell where you want the date and time. You can insert the NOW function into it. Click into the cell, and type an = sign. This tells Excel that you’re beginning to type a formula. Then, type NOW().

Now Excel

Your full formula reads:

=NOW()

Hit Enter on your keyboard, and you’ll see the current date and time appear in your spreadsheet in the format:

4/7/21 15:43

Now function Excel

From here, you have two ways of updating the time. If you close out of your workbook and reopen it, the details will refresh automatically. But if you’re continuing to work in the file, you won’t see the automatic update. To refresh, simply press F9 on your keyboard, and the date and time will update when applicable.

How to Use the NOW Function in Excel (Past and Future)

Suppose now that you want to list the date and time ten days ago, or five days in the future. Since NOW is a formula, you can easily do this.

To display the date and time ten days ago, use the formula:

=NOW()-10

Similarly, to display the date and time five days in the future, use the formula:

=NOW()+5

How to use Now in Excel

Again, keep in mind that these aren’t static blocks of text. Refreshing with F9, or reopening your file, will result in the times and dates updating.

The NOW function is a quick and easy way to work with dates and times in Excel.

Category: Excel FormulasTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Header ExcelHeader in Excel
Next Post:Print Gridlines in ExcelGridlines in print Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top