TODAY

Returns the current date.

Syntax:

=TODAY()

Example:

=TODAY()

Result: Current date

NOW

Returns the current date and time.

Syntax:

=NOW()

Difference

Function

Returns

TODAY()

Current Date

NOW()

Current Date + Time

Practice

Create a worksheet with:

Item

Formula

Today’s Date

=TODAY()

Current Date & Time

=NOW()