NOW
Gives current date with time as per computer’s clock
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)
=NOW() will give current date with time.
For example 1/27/2016 1:21