NOW

Gives current date with time as per computer’s clock

Syntax of Excel Now formula:
=NOW()

In words:
=Give date and time which is (right now)

Examples of Excel Now formula

=NOW() will give current date with time.
For example 1/27/2016 1:21