NOW Function In Excel

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

NOW Function Overview:

The NOW Function returns the current date and time.

To use the NOW Function select a cell and type:

=NOW()

Current Date Only

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

Current Time only

Or only the current time:

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:

Or you can use shortcut CTRL + 1 to select more formatting options, including custom 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