How to use the NOW Function in Excel

In this article, we will learn about how to use the NOW function in Excel to get the current Time.

Dynamic functions are the functions which updates its value.

NOW function is a built-in dynamic function to get current Date and Time in one cell.


For static use of the function use the shortcut key to perform is Ctrl + Shift + ; (semi - colon)


Here are some snapshots to see how it works

NOW function does not take any parameters. It is used with parentheses.

TODAY function used in the A1 cell. TODAY function like NOW function does not take any parameters. It is used with parentheses.

NOW & TODAY function to get the Current Time

Shortcut keys to perform the same function as above
In the B1 cell use Shortcut key to get current date is Ctrl + ; (semi-colon)
In the B2 cell use shortcut key to get current time is Ctrl + Shift + ; (semi-colon)

In the B3 cell use Ctrl + ; (semi-colon) and After single space use Ctrl +Shift + ; (semi-colon) to get both date & time in the same cell.

Note: Dynamic function returns result whenever updated or refreshed whereas static function return results remains constant until & unless edited.

Hope you understood how to use the NOW function to get the current time in Excel. Explore more articles on Excel DATE & TIME function here. Please feel free to state your query or feedback for the above article.

Related Articles:

How to use the TODAY function in Excel

How to Use SUBTOTAL Function in Excel

How to use the Excel LOG10 function

How to use the IMEXP Function in Excel

How to use the IMCONJUGATE Function in Excel

How to use the IMARGUMENT Function in Excel

Popular Articles

Edit a dropdown list

If with conditional formatting

If with wildcards

Vlookup by date

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube