NOW function in Excel

Use

NOW function returns with the current date and time which is keep updated whenever you open the worksheet.

Syntax

=NOW() which has no argument.

Example

Formula Description Result
=NOW() Returns with current date and time. 7/20/2017 14:00
=NOW()+5 Returns with the 5 days later date and time. 7/25/2017 14:00

Formula:

Result:

Copyright © 2016 - 2018 Explainry.com | All Rights Reserved