NOW Function In Excel

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on November 6, 2023

This tutorial demonstrates how to use the NOW Function in Excel to get the current date and time, with formula examples.
now function examples

NOW Function Overview:

The NOW Function returns the current date and time.

To use the NOW Function select a cell and type:


now function example

Current Date Only

You can adjust cell formatting to display only the current date:

now function date only

Current Time only

Or only the current time:

now function time only

Date Time Formatting

To change formatting, you have several options. The easiest is to go to the Home Ribbon and select the Number Formatting Drop Down:

vba date time format

Or you can use shortcut CTRL + 1 to select more formatting options, including custom formatting:

excel number formatting

NOW Examples in VBA

VBA also contains a built-in NOW Function. You can access the function like this:

Sub NowExample()
    Dim tDate As Date
    tDate = Now
    MsgBox tDate
End Sub

now function vba

AI Formula Generator

Try for Free

Excel Practice Worksheet

practice excel worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!

Free Download

Return to List of Excel Functions