top of page

NOW function

Count cells between dates.png

Description

This function returns the current date and time, updated continuously when a worksheet is changes or opened. The NOW function takes no arguments. The returned value could be formatted as a date or date with time by applying a number format.

Objective

Returns current date and time.

Syntax

=NOW()

Arguments

Not available.

bottom of page