Simon Sez IT

Online software training and video tutorials for Microsoft, Adobe & more

  • Course List
    • Adobe
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Flash
        • Flash CS5
      • InDesign
        • InDesign CS6
        • InDesign CS5
      • Photoshop
        • Photoshop CS6
        • Photoshop CS5
        • Adobe Photoshop CS4
      • Photoshop Elements
        • Photoshop Elements 2022
        • Photoshop Elements 2019
        • Photoshop Elements 2018
        • Photoshop Elements 15
        • Photoshop Elements 14
        • Photoshop Elements 13
        • Photoshop Elements 12
        • Photoshop Elements 11
        • Photoshop Elements 10
        • Photoshop Elements 9
        • Photoshop Elements 8
    • Microsoft
      • Access
        • Access 2021 Beginners
        • Access 2019
        • Access 2019 Advanced
        • Access 2016
        • Access 2016 Advanced
        • Access 2013
        • Access 2013 Advanced
        • Access 2010
        • Access 2010 Advanced
        • Access 2007
      • Excel
        • Data Analytics in Excel
        • Excel 2021 Advanced
        • Excel 2021 Intermediate
        • Excel 2021 Beginners
        • PivotTables for Beginners
        • Excel Dashboards
        • Advanced Formulas in Excel
        • Excel for Business Analysts
        • Advanced PivotTables
        • Power Pivot, Power Query and DAX in Excel
        • Excel 2019 Beginners (Mac)
        • Excel 2019 Beginners
        • Excel 2019 Advanced
        • Excel 2016 Beginners
        • Excel 2016 Intermediate
        • Excel 2016 Advanced
        • Excel 2013
        • Excel 2013 Advanced
        • Excel 2010 Beginners
        • Excel 2010 Advanced
        • Excel 2007
      • OneNote
        • OneNote Desktop and Windows 10
        • OneNote 2016
      • Outlook
        • Outlook 2021
        • Outlook 2019
        • Outlook 2016
        • Outlook 2013
        • Outlook 2010
        • Outlook 2007
      • Power Automate
        • Introduction to Power Automate
      • Power BI
        • Power BI
        • Power BI Intermediate
      • PowerPoint
        • PowerPoint 2021
        • PowerPoint 2019
        • PowerPoint 2016
        • PowerPoint 2013
        • PowerPoint 2010
        • PowerPoint 2007
      • Project
        • Project 2021 Beginners
        • Project for the Web
        • Project 2019
        • Project 2019 Advanced
        • Project 2016
        • Project 2016 Advanced
        • Project 2013
        • Project 2013 Advanced
        • Project 2010
        • Project 2010 Advanced
      • Publisher
        • Publisher 2013
      • SharePoint
        • SharePoint Online
        • SharePoint Foundation 2013
        • SharePoint Server 2013
        • SharePoint Foundation 2010
      • Teams
        • Microsoft Teams (2023 Update)
      • VBA
        • Macros and VBA for Beginners
        • VBA for Excel
        • VBA Intermediate Training
      • Visio
        • Microsoft Visio 2019
        • Visio 2016
        • Visio 2013
        • Microsoft Visio 2010
      • Windows
        • Windows 11 (2023 Update)
        • Windows 10 (2020 Update)
        • Windows 10
        • Windows 8
        • Windows 7
        • Windows Vista
      • Word
        • Word 2021
        • Word 2019 Advanced
        • Word 2019
        • Word 2016
        • Word 2013
        • Word 2010
        • Word 2007
    • QuickBooks
      • QuickBooks
        • QuickBooks Desktop Pro 2022
        • QuickBooks Pro 2021
        • QuickBooks Online Advanced
        • QuickBooks Online
        • QuickBooks Canada
        • QuickBooks Pro 2020
        • QuickBooks 2019
        • QuickBooks 2018
        • QuickBooks Pro 2017
        • QuickBooks Pro 2016
        • QuickBooks Pro 2015
        • QuickBooks Pro 2014
        • QuickBooks Pro 2013
        • QuickBooks Pro 2012
        • QuickBooks Pro 2011
        • QuickBooks Pro 2010
        • QuickBooks Pro 2009
    • Web Development
      • AngularJs
        • AngularJS Crash Course
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Bootstrap
        • Bootstrap Framework
      • Html/CSS
        • HTML/CSS Crash Course
        • HTML5 Essentials
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
      • Java
        • Java for Beginners
      • JavaScript
        • JavaScript for Beginners
        • jQuery Crash Course
      • MySql
        • MySQL for Beginners
      • PHP
        • PHP for Beginners
        • Advanced PHP Programming
      • XML
        • XML Crash Course
    • Data Analysis
      • Financial Modeling
        • Financial Risk Management
        • Financial Forecasting and Modeling
      • Data Analytics
        • Introduction to Analytics and Artificial Intelligence
        • Data Analytics in Excel
      • Alteryx
        • Alteryx Advanced
        • Introduction to Alteryx
      • Power BI
        • Power BI Intermediate
        • Power BI
      • Qlik Sense
        • Qlik Sense Advanced
        • Qlik Sense
      • R Programming
        • R Programming
      • Tableau
        • Tableau Desktop Advanced
        • Tableau Desktop
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
    • Work Productivity
      • Google Sheets
        • Google Sheets for Beginners
      • Confluence
        • Introduction to Confluence
      • Monday
        • Getting Started in Monday.com
      • Asana
        • Asana for Employees and Managers
        • Introduction to Asana
      • Jira
        • Getting Started in Jira
  • For Business
  • About Us
    • Testimonials
    • Contact Us
    • FAQ
    • Membership
    • About Us
  • Pricing
  • Free Resources
  • Sign In
  • Get Started
Home > Microsoft Excel > How to Use the Excel NOW Function? 3 Examples

How to Use the Excel NOW Function? 3 Examples

Note: This tutorial on how to use the Excel NOW Function is suitable for all Excel versions including Office 365. 

Have you ever wondered how to use the current date and time inside a spreadsheet without manually entering the value each time? The NOW function in Excel solves this issue. In this guide, I’ll walk you through the NOW function’s syntax and explain how to use it properly with the help of some examples. 

You’ll learn:

  • NOW Function in Excel 
  • Excel NOW Function Syntax
  • How to Use the NOW Function in Excel? 
    • Example 1: NOW Function to Display Current Date and Time
    • Example 2: NOW Function to Set Appointment Alerts
    • Example 3: NOW Function Miscellaneous Uses
  • Other Reasons to Use the NOW Function
  • How to Make the NOW() Function Static? 

Related:

How to Use the NPER Excel Formula: 2 Easy Examples

The Excel SMALL Function – 3 Best Examples

The Excel CHOOSE Function – 4 Best Uses

NOW Function in Excel 

The NOW function will return the serial value of the current date and time This can either be directly displayed or used inside other functions to calculate other time-dependent values. 

In Excel, all dates are actually stored as sequential serial numbers starting with 1 for 1st January 1900. This means that the number 30 signifies 30th January 1900, and the number 44600 signifies 8th February 2022. 

Date and Time Serial Numbers in Excel
Date and Time Serial Numbers in Excel

If used directly in a cell, it will automatically convert the cell formatting to the regional date and time format. It is important to remember that the NOW function is volatile in nature. That is, it resets its value to the current time and date whenever the worksheets are opened or calculated. 

Excel NOW Function Syntax

The NOW formula’s syntax is very straightforward. 

=NOW()

Please note that the parentheses have to remain empty for the function to work properly, i.e the function should have no arguments. 

How to Use the NOW Function in Excel? 

There is nothing too complicated about using the NOW function in Excel. But, there are some important things to remember while using it. The following examples will help illustrate these better. 

Example 1: NOW Function to Display Current Date and Time

This is the plain and simple application of the Excel NOW function. Directly enter the =NOW() formula into a cell to display the current date and time inside it. The date and time value will be updated whenever the sheet is opened again or formulas are calculated. You can manually update this by pressing F9. 

Excel NOW Function to Display Date and Time
Excel NOW Function

Example 2: NOW Function to Set Appointment Alerts

Let’s say for example your job is to manage your boss’s appointments and you have set up an Excel spreadsheet to track them. Now, you want to create a dashboard that alerts you about nearing appointments in the next 1 hour. 

You can easily do this using the Excel NOW function by following these steps:

  1. Enter the time and date of the upcoming appointment in the standard date and time format in, let’s say, cell C9. 
  1. In a different cell, use the formula =IF(C9-NOW()<1/24,” Meeting in 1 Hour ”, “ No Meeting in Next 1 Hour “) 

    This formula finds the difference in time between the scheduled appointment and the current time to alert the user if it is less than 1 hour. 
Use the NOW Function in Excel to set appointment alerts

To improve this further you can set conditional formatting based on the IF condition and even set up notification alerts using VBA macros. Please note that this will work only if the spreadsheet is updated or re-opened. 

Also Read:

How to Use Goal Seek in Excel? (3 Simple Examples)

How to Insert Multiple Rows in Excel? The 4 Best Methods

How to Autofit Excel Cells? 3 Best Methods

Example 3: NOW Function Miscellaneous Uses

Its applications don’t stop there. You can do any of the following date and time-related operations with the Excel NOW function.

Excel NOW Function - Date and Time Calculations
Excel NOW Function – Date and Time Calculations

Please remember that when using data and time-related calculations, a unit of 1 implies 1 day and 1/24th of a unit implies an hour. 

Other Reasons to Use the NOW Function

The NOW function is usually used before printing spreadsheets to display the time and date when the printout was taken. 

One more important use case of the NOW function is to keep track of the duration of any particular process. It can be used manually or automated with VBA to record the start time and finish time of a process to calculate its duration. 

How to Make the NOW() Function Static? 

The only way to make the NOW function’s time static is to copy its contents and paste them as values somewhere else. You can use the keyboard shortcut Ctrl+C to copy it and Alt+E+S+V to paste special as value. 

Alternatively, if you want to avoid all of this and directly print a static value of the current time, use the shortcut 
Ctrl + Shift + ;

If you want to include the current date, use Ctrl +; to first print the date, add a space and follow it up with
Ctrl + Shift +; 

Suggested Reads:

How to Group Worksheets in Excel? (In 3 Simple Steps)

How to Shade Every Other Row in Excel? (5 Best Methods)

How to Use the Excel Fill Handle Easily? (Top 3 Uses with Examples)

Closing Thoughts

In this short guide, I have shown how to properly use the NOW function in Excel. I hope you find this very useful in your spreadsheet calculations. If you have any questions about this or any other Excel feature, feel free to let us know in the comments. We’re always happy to help. 

Visit our free Excel Resources Centre for more high-quality Excel guides. 

Want to learn more about Excel? Click here to access our advanced Excel courses with in-depth training modules. 

You can train your entire team in Excel and other business software, for a single low monthly fee by clicking here. 

Adam Lacey

Adam Lacey is an Excel enthusiast and online learning expert. He combines these two passions at Simon Sez IT where he wears a number of different hats. When Adam isn't fretting about site traffic or Pivot Tables, you'll find him on the tennis court or in the kitchen cooking up a storm.

Most Popular Posts

  • Kanban vs Scrum: Project Management Methodologies and Their Differences [2022]
  • How to Insert a Checkbox in Excel? 3 EASY Examples
  • How to Autofit Excel Cells? 3 Best Methods
  • XLOOKUP Google Sheets – 4 Best Alternatives!
  • Dashboards in Excel Using Pivot Tables, Pivot Charts and Slicers
  • Free Microsoft Project Training Course
  • Free Microsoft Access Tutorial for Beginners (3.5 Hours Video)
  • How to Use Blending Mode With Layers in Adobe Photoshop Elements 15

Similar Posts

How to Fix the Excel NAME Error? 3 Simple Tips

Publisher 2013 – How to Create a New Publication

Using the History Panel in Dreamweaver CS6

Introduction to Jira Boards [2022]

How To Setup Preferences in QuickBooks Pro 2017 Part 1

How to Select Non Adjacent Cells in Excel? 5 Simple Ways

Course Categories

  • Adobe
  • Data Analysis
  • QuickBooks
  • Microsoft
  • Web Development
  • Work Productivity

About Us

  • About Us
  • Free Resources
  • Affiliates
  • Become an Instructor

Products

  • Pricing and Plans
  • Business Pricing
  • Government Discounts
  • Non-Profit Discounts

Support

  • FAQ’s
  • Contact Us
  • DVD support

Connect

YoutubeFacebookLinkedIn
© 2023 Simon Sez IT, Inc.
  • Terms
  • Privacy Policy
  • Sitemap
888.817.6665 Monday thru Friday 7:30 a.m. - 5:00 p.m. (ET)